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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
enrooting1012813(None) 
unrooting1098831unrooting
enrobing1137432enr_obing
enrolling1087732enrolling
rooting83522432__rooting
snooting92813192sn_ooting
unroofing1385702unroofing
uprooting1276902uprooting
booting103821363__booting
brooding122911373_brooding
brooking153710703_brooking
brooming132911143_brooming
crooking153611343_crooking
crooning113112113_crooning
defrosting1544493defrosting
denoting10311753den__oting
disrooting1247743disrooting
drooling102610423_drooling
drooping12268803_drooping
emoting10313563e__moting
enacting11311363en_acting
enamoring1247033enamoring
enclosing1257573enclosing
encoding1239043en_coding
encoring11312173en_coring
encrusting13125293encrusting
encrypting1843053encrypting
encysting1544613encysting
enditing10311073en_diting
endorsing1147303endorsing
endowing13178173en_dowing
enervating1488433enervating
enfolding1444833enfolding
enforcing1545473enforcing
engorging1244873engorging
engrafting1544183engrafting
engrossing12124643engrossing
enjoining1745053enjoining
enjoying1935003en_joying
enlisting1038343enlisting
ennobling1244123ennobling
enraging1049573enr_aging
enriching1546153enriching
enroot6615993enroot___
enrooted977423enroot_ed
enroots738713enroot__s
ensouling1046003ensouling
entoiling1038483entoiling
entombing1444893entombing
entreating11811553entreating
entrusting11126183entrusting
enwombing1742943enwombing
enzootic1944323enzooti_c
enzootics2042453enzootics
erecting112415063e_recting
eroding9314273e_r_oding
eructing112110173e_ructing
erupting11218443e_rupting
escorting1237713escorting
escoting1158713e_scoting
exhorting2045733exhorting
exporting1937323exporting
extorting1746763extorting
footing115017593__footing
fronting12310443_fronting
frosting12311183_frosting
garoting10510703gar_oting
garotting1136103garotting
garroting1136953garroting
grooming12309513_grooming
grooving13286713_grooving
grouting103410793_grouting
hooting113919873__hooting
ingoting1039863in_goting
intorting10311413intorting
knotting13236573kn_otting
knouting13226793kn_outing
looting83019643__looting
marooning1238593marooning
mooting103019363__mooting
nonrioting1146753nonrioting
nooning83014853_n_ooning
noosing83315053_n_oosing
noting74120153_n__oting
onlooking1444453onlooking
outrooting1147933outrooting
parroting1239153parroting
promoting1439913_promoting
proofing1439313_proofing
rebooting12139023rebooting
refronting1437273refronting
regrooming1464163regrooming
regrooving1553503regrooving
reroofing1336863reroofing
rerouting10311873rerouting
reshooting1436223reshooting
rioting82716393__rioting
roofing113814353__roofing
rooking123517363__rooking
rooming104117043__rooming
roosing84018133__roosing
roosting93411453__roosting
rootling9269953__rootling
rotting82919683__rotting
routing83821093__routing
scooting113012633_scooting
scrooping1446593scrooping
shooting122812853_shooting
snooding102910433sn_ooding
snooking133010583sn_ooking
snooling93013473sn_ooling
snooping113811323sn_ooping
snoozing18319073sn_oozing
snorting92613373sn_orting
snouting92511923sn_outing
sooting82820953__sooting
sprouting1236943sprouting
throating1398383throating
tooting83019423__tooting
trooping112710273_trooping
trotting92510913_trotting
unbolting1236453unbolting
uncoating12611923uncoating
unhooding1435893unhooding
unhooking1735353unhooking
unloosing1036113unloosing
unmooring1255813unmooring
unquoting1944763unquoting
unresting10311133unresting
unrobing1138063unr_obing
unrolling1078563unrolling
varooming1545083varooming
vrooming14287353_vrooming

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.250714764.0
2DLD Change Limit1486411338.56317358.5
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.87620131.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.