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

74 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
walkouts154425(None) 
walkout1447931walkout_
backouts1698642backouts
fallouts1137882fallouts
walkabouts1951562walkabouts
walkups1633012walk_ups
walnuts1033842wal_nuts
washouts1445902washouts
workouts1544962workouts
allots64019173_allo_ts
awlworts1443593awlworts
backout15612953backout_
bailouts1036613bailouts
ballots94116033ballo_ts
blackouts1745153blackouts
callous93516593callou_s
campouts1436823campouts
clouts87017203_cl_outs
cookouts1445993cookouts
dakoits1245293da_koits
eelpouts1044323eelpouts
fadeouts1245693fadeouts
fallout10313503fallout_
flouts94315273_fl_outs
foldouts1244773foldouts
galiots82311323galio_ts
gallnuts943923gallnuts
galloots9268963galloots
gallous82813953gallou_s
galoots82410793gal_oots
glouts74414713_gl_outs
hackbuts1943873hackbuts
halibuts1364443halibuts
handouts1238233handouts
hangouts1236183hangouts
holdouts1245473holdouts
layouts1046483la_youts
lockouts1445493lockouts
lookouts1244563lookouts
louts56330273__l_outs
mahouts1237143ma_houts
payouts1247303pa_youts
pullouts1045223pullouts
ragouts838533ra_gouts
rainouts846913rainouts
rollouts8136723rollouts
sackbuts1644053sackbuts
sellouts837483sellouts
sickouts1455503sickouts
takeouts1245363takeouts
talcous939483talcou_s
valours10248733val_ours
wackos155210993wacko__s
walkabout1852853walkabout_
walkers143411473walk_ers
walkings16327313walkings
walkover1842943walkover
walkovers1942613walkovers
walks126218503walk___s
walkup1534193walk_u_p
walkways2143213walkways
wallets103914833wal_lets
wallops123410413wallo_ps
wallows133613533wallo_ws
walnut939433wal_nut_
walrus956433wal_ru_s
warmouth1644143warmouth
warmouths1742853warmouths
washout13410133washout_
watchouts1744033watchouts
wideouts1275233wideouts
wipeouts1354203wipeouts
withouts1445113withouts
workout1448393workout_

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162748.64316911.0
3Display Results74740.0302466.7
 (SQL Overall)178691748.82920239.1
 
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.