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

123 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
outfoots113688(None) 
outfools1136531outfools
outfoot10411491outfoot_
outroots839871outroots
hotfoots1444322hotfoots
outcooks1436712outcooks
outdoors936422outdoors
outfasts11117232outfasts
outfits102210832outf_its
outfloats1243572outfloats
outflows1445462outflows
outfool1037332outfoo_l
outfooted1345892outfooted
outfoxes1836742outfoxes
outlooks1236792outlooks
outplots1086362outplots
outports1048272outports
outposts1037252outposts
outroot7516562outroot_
outshoots1245382outshoots
outtrots838372outtrots
bigfoots1443633bigfoots
buffoons1643093buffoons
coltsfoots1551583coltsfoots
cutouts938013cut_outs
finfoots1444153finfoots
flatfoots1542933flatfoots
foots85528283___foots
gumboots1344253gumboots
hotfoot1347053hotfoot_
nutwoods1244263nutwoods
outacts9310213out_acts
outblooms1342973outblooms
outboast1048543outboast
outboasts1144763outboasts
outboxes1737823outboxes
outcasts10108683outcasts
outcomes1239753outcomes
outcook1337203outcoo_k
outcounts1144773outcounts
outcrops1246843outcrops
outcross1036813outcross
outcrows1346643outcrows
outdoers937503outdoers
outdoes8313113out_does
outdoor836703outdoo_r
outdoorsy1341773outdoorsy
outdrops1136543outdrops
outeats72215703out_eats
outfaces132311393outfaces
outfalls1138143outfalls
outfast101412123outfast_
outfawns1434723outfawns
outfeast11107503outfeast
outfeasts12114323outfeasts
outfeels1135063outfeels
outfelt10310603outfelt_
outfights1643783outfights
outfinds1235643outfinds
outfires1139863outfires
outfit93014943outf_it_
outflies11310143outflies
outfloat1146243outfloat
outflow1355353outflo_w
outflown1464063outflown
outfooled1345493outfooled
outfooting1445653outfooting
outfound1245763outfound
outfox1636133outf_o_x
outfoxed1936013outfoxed
outfrown1444863outfrown
outfrowns1543813outfrowns
outglows1244933outglows
outgoes8312643out_goes
outgross936423outgross
outgrows1236283outgrows
outhits102213503out_hits
outhowls1445713outhowls
outhunts1136033outhunts
outjuts1476473out_juts
outlasts8108713outlasts
outlets73616363out_lets
outlook1138023outloo_k
outloves11249673outloves
outmodes11208963outmodes
outmost9511213outmost_
outmoves13228173outmoves
outplods11105613outplods
outplot9109483outplot_
outpoints1145703outpoints
outpolls1046213outpolls
outport9714123outport_
outpost9612443outpost_
outpours1036653outpours
outputs988493out_puts
outquote1775293outquote
outquotes1874513outquotes
outroars838903outroars
outrocks1437903outrocks
outrolls847823outrolls
outrooted1047623outrooted
outrows10311403out_rows
outscoops1343403outscoops
outserts8309803outserts
outsets73514923out_sets
outshoot1149163outshoot_
outshot10312103outshot_
outshouts1245193outshouts
outsits73215253out_sits
outsoars838833outsoars
outsoles8813113outsoles
outtrot7312613outtrot_
outvote1038803out_vote
outvotes1137903outvotes
outwaits1137493outwaits
outwits103110863out_wits
outworks15148973outworks
outwrote1137723outwrote
putouts937083put_outs
toots55331873__t_oots
unroots738563_unroots
uproots937143_uproots
utmosts934593_utmosts

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.1561145455.1
2DLD Change Limit1461621237.42319690.4
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.64223382.8
 
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.