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 “dolomites” with Change Limit: [1] [2] [3] [4]

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

63 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
dolomites124808(None) 
dolomite1148131dolomite_
dolerites101410892dolerites
dolomitic1445232dolomitic
dolomitizes2353442dolomitizes
rolamites1148242rolamites
sodomites12137192sodomites
boehmites1663023boehmites
bolometer1348213bolometer
bolometers1447383bolometers
calamites13410713calamites
chlorites142311963chlorites
chromites16310963chromites
coelomates1497573coelomates
colocates13312853colocates
colonies103620013coloni_es
colonises112814013colonises
colonitis1148763colonitis
colonizes202613183colonizes
colorizes203014523colorizes
columbites1643693columbites
delimited1346593delimited
delimiter1246243delimiter
delimiters1345103delimiters
delimits1137573delimit_s
diatomites1345363diatomites
diorites9313523d_iorites
diplomates1576073diplomates
dolerite9611773dolerite_
dollies83620983dol_li_es
dolmades1245463dol_mades
dolomitize2253183dolomitize
dolomitized2452723dolomitized
domines102918973d__omines
doobies103915673do_obi_es
doodies94218773do_odi_es
doolies83920713do_oli_es
doomier103610123do_omi_er
doomiest112910453do_omi_est
doomster1135843do_omster
doomsters1236173do_omsters
doozies173812723do_ozi_es
dopamines1446043dopamines
dynamites1544623dynamites
eclogites1245263eclogites
eolopiles1145823eolopiles
folkmotes1883283folkmotes
fomites123613203__fomites
iolites73819483iol__ites
limites92915453__limites
locomotes1346333locomotes
mylonites1446453mylonites
ologies8615023_ologi_es
oolites72817843_o_olites
oologies9312993oologi_es
polemizes2248153polemizes
rolamite1048743rolamite_
roomies93017243ro_omi_es
sodomies11128553sodomi_es
sodomite11136913sodomite_
sodomizes21125663sodomizes
somites94219123__somites
totemites1146613totemites

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 Filter1786911486410.453394461.4
2DLD Change Limit148641637.56319653.7
3Display Results63630.0163937.5
 (SQL Overall)178691638.03222247.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.