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 “sunrooms” 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.

68 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
sunrooms104572(None) 
gunrooms1144321gunrooms
sunroofs1144761sunroofs
sunroom947011sunroom_
gunroom1045052gunroom_
mudrooms1344082mudrooms
sunroof1047052sunroo_f
unroofs1035782_unroofs
unroots738562_unroots
barrooms1237893barrooms
bedrooms1345713bedrooms
brooms104915873__brooms
clubrooms1542933clubrooms
dayrooms1444343dayrooms
enroots738713_enroots
grooms94512523__grooms
legrooms1185413legrooms
lunchrooms1752443lunchrooms
mudroom1244953mudroom_
mushrooms1672763mushrooms
outroots839873outroots
regrooms1196013regrooms
rooms75324683___rooms
salerooms1146433salerooms
santoors837633santoors
scroops11288243s_croops
sheroots1137863sheroots
shnooks1485583shn_ooks
showrooms1743383showrooms
sickrooms1743433sickrooms
simooms1135573s_imooms
snoods74312453s_n_oods
snooks104412833s_n_ooks
snools65715883s_n_ools
snoops84314173s_n_oops
snoots64216683s_n_oots
sonhoods1247083sonhoods
sonorous8410413sonorous
stardoms1136793stardoms
subatoms1245883subatoms
subcools1245753subcools
sucroses1039933sucroses
sunbeams1243963sunbeams
sunbows1236023sun_bows
sundogs947103sun_dogs
sundowns1285433sundowns
sundrops1145823sundrops
sunglows1244083sunglows
sunproof1344603sunproo_f
sunrays1037083sunr_ays
sunrises8310693sunrises
sunspots1045083sunspots
supermoms1547303supermoms
supremos1245813supremos
syncoms1435943syn_coms
taprooms1246663taprooms
tearooms1047843tearooms
unbosoms1243263_unbosoms
unhoods1137503_unhoods
unhooks1436413_unhooks
unmoors945903_unmoors
unrobes9269733_unrobes
unrolls797793_unrolls
unroof9410193_unroo_f
unroot6315553_unroo_t
uproots937143_uproots
varooms1248883_varooms
vrooms11398713__vrooms

Search took 8 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 Filter1786911461620.1701051123.5
2DLD Change Limit146162686.98620922.1
3Display Results68680.0135230.8
 (SQL Overall)178691687.16924925.5
 
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.