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

156 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
outroots83987(None) 
outfoots1136881outfoots
outroot7516561outroot_
outcooks1436722outcooks
outdoors936432outdoors
outfools1136532outfools
outfoot10411492outfoot_
outlooks1236792outlooks
outplots1086362outplots
outports1048272outports
outposts1037252outposts
outroars838922outroars
outrocks1437902outrocks
outrolls847822outrolls
outrooted1047622outrooted
outrows10311402outr_ows
outshoots1245392outshoots
outtrots838372outtrots
unroots738562_unroots
uproots937142_uproots
alumroots1142883alumroots
beetroots1144013beetroots
burbots1168673bu_rbots
cheroots1348193cheroots
clubroots1342983clubroots
coatrooms1385413coatrooms
courtrooms1452633courtrooms
cutouts938033cut_outs
disroots948623disroots
dogtrots1044693dogtr_ots
enroots738713_enroots
foxtrots1843923foxtr_ots
gumboots1344253gumboots
gunrooms1144323gunrooms
hotfoots1444323hotfoots
introits859713introits
mudrooms1344083mudrooms
muskroots1542483muskroots
nutwoods1244263nutwoods
octoroons1143423octoroons
octrois938333octr_ois
outacts9310213out_acts
outblooms1342973outblooms
outboast1048543outboast
outboasts1144763outboasts
outboxes1737823outboxes
outcasts10108683outcasts
outcomes1239763outcomes
outcook1337203outcoo_k
outcounts1144793outcounts
outcrops1246853outcrops
outcross1036823outcross
outcrowds1553353outcrowds
outcrows1346653outcrows
outdoers937513outdoers
outdoes8313123out_does
outdoor836713outdoo_r
outdoorsy1341783outdoorsy
outdrops1136543outdrops
outeats72215703out_eats
outercoats1244243outercoats
outermost1146133outermost
outfasts11117233outfasts
outfits102210833out_fits
outfloats1243573outfloats
outflows1445463outflows
outfool1037333outfoo_l
outfooted1345893outfooted
outfoxes1836743outfoxes
outfrowns1543813outfrowns
outglows1244933outglows
outgoes8312643out_goes
outgross936423outgross
outgroups1243293outgroups
outgrows1236283outgrows
outgrowth1663103outgrowth
outgrowths1781903outgrowths
outhits102213503out_hits
outhowls1445723outhowls
outhunts1136033outhunts
outjuts1476493out_juts
outlasts8108713outlasts
outlets73616363out_lets
outlook1138023outloo_k
outloves11249673outloves
outmodes11208963outmodes
outmost9511213outmost_
outmoves13228173outmoves
outplods11105613outplods
outplot9109483outplot_
outpoints1145703outpoints
outpolls1046213outpolls
outport9714123outport_
outpost9612443outpost_
outpours1036683outpours
outputs988493out_puts
outquote1775293outquote
outquotes1874513outquotes
outraces102217863outraces
outrages92215933outrages
outranks12298823outranks
outrate72323183outr_ate
outrates82421373outrates
outraves112313833outraves
outreads9289003outreads
outrides92414993outrides
outrigs82811263outr_igs
outrings92811053outrings
outroar739513outr_oar
outrock1339303outr_ock
outrode82313423outr_ode
outroll749303outr_oll
outrooting1147933outrooting
outrow9311183outr_o_w
outrowed1239433outrowed
outruns72911543outr_uns
outscoops1343403outscoops
outserts8309803outserts
outsets73514923out_sets
outshoot1149163outshoot_
outshot10312103outshot_
outshouts1245213outshouts
outsits73215253out_sits
outsoars838853outsoars
outsoles8813113outsoles
outtrot7312613outtrot_
outvote1038803out_vote
outvotes1137903outvotes
outwaits1137493outwaits
outwits103110863out_wits
outworks15148973outworks
outwrote1137723outwrote
patriots1038053patriots
patroons102710603patroons
pokeroots1544063pokeroots
poltroons1145393poltroons
putouts937083put_outs
puttyroots1551833puttyroots
redroots937753redroots
roots55933673___roots
roseroots945293roseroots
sheroots1137863sheroots
sunroofs1144763sunroofs
sunrooms1045723sunrooms
surtouts846203surtouts
taproots1047253taproots
toots55331873__t_oots
troops85712783__troops
trots56629943__tr_ots
trouts66116633__trouts
turbots988023tu_rbots
unroofs1035783_unroofs
unroot6315553_unroot_
uproot8314123_uproot_
utmosts934593_utmosts
wormroots1442723wormroots

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.450397091.1
2DLD Change Limit1461621567.33019940.2
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.84322783.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.