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

55 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
sunroofs114476(None) 
sunroof1047051sunroof_
sunrooms1045721sunrooms
unroofs1035781_unroofs
gunrooms1144322gunrooms
sunproof1344602sunproof_
sunroom947012sunroo_m
unroof9410192_unroof_
unroots738562_unroots
enroots738713_enroots
gunroom1045053gunroo_m
moonroofs1443253moonroofs
mudrooms1344083mudrooms
outroots839873outroots
proofs114511683__proofs
reproofs1346063reproofs
reroofs1037943_reroofs
roofs85321153___roofs
runoffs1343013run_offs
santoors837633santoors
scroops11288253s_croops
sendoffs1543493sendoffs
shadoofs1554233shadoofs
sheroots1137863sheroots
shnooks1485583shn_ooks
shroffs1634363s_hroffs
snoods74312453s_n_oods
snooks104412833s_n_ooks
snools65715883s_n_ools
snoops84314173s_n_oops
snoots64216683s_n_oots
sonhoods1247083sonhoods
sonorous8410413sonorous
soundproofs1781353soundproofs
spoofs114011813s__poofs
subcools1245753subcools
sucroses1039933sucroses
sunbows1236023sun_bows
sundogs947103sun_dogs
sundowns1285433sundowns
sundrops1145823sundrops
sunglows1244083sunglows
sunrays1037083sunr_ays
sunrises8310693sunrises
sunspots1045083sunspots
surfs85022543su_r__fs
turnoffs1442833turnoffs
unhoods1137503_unhoods
unhooks1436413_unhooks
unmoors945903_unmoors
unrobes9269733_unrobes
unrolls797793_unrolls
unroofed12106773_unroofed
unroot6315553_unroo_t
uproots937143_uproots

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.423422437.4
2DLD Change Limit146162557.37319824.0
3Display Results55550.0163437.5
 (SQL Overall)178691557.81222873.9
 
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.