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

111 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
outfools113653(None) 
outfool1037331outfool_
outfoots1136881outfoots
outcooks1436722outcooks
outdoors936432outdoors
outfalls1138142outfalls
outfeels1135062outfeels
outflows1445462outflows
outfooled1345492outfooled
outfoot10411492outfoo_t
outfoxes1836742outfoxes
outhowls1445722outhowls
outlooks1236792outlooks
outpolls1046212outpolls
outrolls847822outrolls
outroots839872outroots
batfowls1642773batfowls
befools1236433_befools
buffoons1643093buffoons
butanols1044713butanols
fools86824203___fools
hotfoots1444323hotfoots
jetfoils1842453jetfoils
nutwoods1244263nutwoods
octanols1044553octanols
outbawls1336053outbawls
outblooms1342973outblooms
outboxes1737823outboxes
outcalls1038743outcalls
outcomes1239763outcomes
outcook1337203outcoo_k
outcrops1246853outcrops
outcross1036823outcross
outcrows1346653outcrows
outdoers937513outdoers
outdoes8313123out_does
outdoor836713outdoo_r
outdoorsy1341783outdoorsy
outdrops1136543outdrops
outduels945053outduels
outfable1378813outfable
outfables1485563outfables
outfaces132311393outfaces
outfall1039683outf_all
outfasts11117233outfasts
outfawns1434723outfawns
outfeel1037543outfeel_
outfelt10310603outf_elt
outfield1265253outfield
outfields1373123outfields
outfinds1235643outfinds
outfires1139863outfires
outfits102210833outf_its
outflies11310153outflies
outfloat1146243outfloat
outfloats1243573outfloats
outflow1355353outflo_w
outflown1464063outflown
outfly1238273outf__ly
outfooling1445473outfooling
outfooted1345893outfooted
outfound1245763outfound
outfox1636143outf_o_x
outfoxed1936013outfoxed
outfrown1444863outfrown
outfrowns1543813outfrowns
outglows1244933outglows
outgoes8312643out_goes
outgross936423outgross
outgrows1236283outgrows
outhauls1137223outhauls
outhowl1337203outhowl_
outkills1245143outkills
outlook1138023outloo_k
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outplods11105613outplods
outplots1086363outplots
outpoll946793out_poll
outports1048273outports
outposts1037253outposts
outpours1036683outpours
outpulls1065443outpulls
outroars838923outroars
outrocks1437903outrocks
outroll749303out_roll
outroot7516563outroo_t
outrows10311403out_rows
outsails8139863outsails
outscold11115253outscold
outscolds12113653outscolds
outscoops1343403outscoops
outsells888653outsells
outshoots1245393outshoots
outsoars838853outsoars
outsold8109073out_sold
outsole71013433out_sole
outsoles8813113outsoles
outtells896853outtells
outtold8107603out_told
outtrots838373outtrots
outvotes1137903outvotes
outwills1135653outwills
outworks15148973outworks
outyells11105303outyells
retools73411023ret_ools
stools65117023_st_ools
subcools1245763subcools
tomfools1343543tomfools
tools55325243__t_ools

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.406440125.6
2DLD Change Limit1461621116.53322372.9
3Display Results1111110.0601850.0
 (SQL Overall)1786911116.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.