Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “rhinoplasties” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

32 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
rhinoplasties186202(None) 
rhinoplasty1962333rhinoplast__y
angioplasties1661874angioplasties
homoplasies18105244_homoplas_ies
neoplasties1353674__neoplasties
osteoplasties1562234osteoplasties
otoplasties1353544__otoplasties
rhinologies1546504rhino_l_ogies
rhizoplanes2552144rhizopla__nes
shinplaster1651934shin_plast_er
shinplasters1751854shin_plasters
chiropractics2161665chiropractics
epinasties1243795epin___asties
homoplastic2055805_homoplasti_c
hyponasties1953555_hypo_nasties
hypoplasias2155225_hypoplas_ias
hypoplastic2356235_hypoplasti_c
keratoplasties2071505keratoplasties
nonplastics1554635___nonplastics
phenolates1547015pheno_la_t_es
proplastids1654325__proplastids
reinflates13137215rein_fla_t_es
reinoculates1454235reinocula_t_es
retinopathies1861645retinop_athies
rhinoscopies1953815rhino_scopies
rhizoplane2462085rhizopla__ne_
rhizopuses2451515rhizop_us__es
thermoplastics2362635thermoplastics
tinplates1147775_tin_pla_t_es
tonoplasts1255185_tonoplast__s
vinblastines1751225_vin_blastines
whiplashes2152065whi__plas_hes

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911247900.1401276364.3
2DLD Change Limit124790328.26615096.8
3Display Results32320.0132461.5
 (SQL Overall)178691328.41921224.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.