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

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

109 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
toilers7411626(None) 
boilers93417061boilers
coilers93619901coilers
moilers93615201moilers
oilers64721191_oilers
tailers73720181tailers
tilers63523501t_ilers
toiler63918281toiler_
toiles63923511toile_s
toilets74112911toilets
tollers73217461tollers
toolers74416501toolers
bailers94221352bailers
boiler84319272boiler_
bowlers123715782bowlers
broilers103210092broilers
ceilers93912532ceilers
coalers94419352coalers
coiler84421592coiler_
coiners93620752coiners
coolers93522492coolers
etoiles7411292etoile_s
exilers14419732exilers
filers94623722_filers
fowlers133411202fowlers
goiters84014442goiters
hailers104017262hailers
hollers103818232hollers
howlers133312352howlers
jailers144114042jailers
joiners144211572joiners
loiters74116612loiters
lollers72713792lollers
mailers94420332mailers
milers84625162_milers
moiler84017262moiler_
nailers73215892nailers
oglers74313182_oglers
oiler54628282_oiler_
poisers94214432poisers
polers84225642po_lers
pollers93420022pollers
poolers94217422poolers
railers74420672railers
rollers73117472rollers
sailers73822322sailers
smilers94113852smilers
spoilers10238632spoilers
tailer63823732tailer_
tailors73212392tailors
talers64628152t_alers
tellers73717612tellers
thalers106212262thalers
tiers55526522t_i_ers
tigers75616512t_igers
tiler56131022t_iler_
tiles55542102t_ile_s
tillers73418742tillers
tilters73315952t_ilters
timers84420992t_imers
titers64526412t_iters
tochers123413092tochers
toddlers10346962toddlers
toeless72612392toeless
togglers10276952togglers
toile54626492toile__
toiled74420322toile_d
toilet66228092toile_t
toiletry1144102toiletry
toils54527492toil__s
tokers104818892to_kers
tolars64817942to_lars
toles55147132to_le_s
toller63819442toller_
toners64128002to_ners
tongers84116012tongers
tonlets73212502tonlets
tonners73816402tonners
tooler63818612tooler_
tooters73818772tooters
tootlers8289502tootlers
topers85025322to_pers
topless92511122topless
toppers113914602toppers
tossers74713502tossers
toters65026362to_ters
totters74618732totters
tourers73512742tourers
touters74018352touters
towers94423672to_wers
toyers95516332to_yers
toyless10268712toyless
trailers82912932trailers
triers64321522tri_ers
triflers113110222triflers
trillers83613492trillers
trimers94615142trimers
trollers83211212trollers
twiers95410162twi_ers
twiners10459632twiners
twirlers11274302twirlers
veilers103911822veilers
voicers12348992voicers
voiders11279822voiders
voiles94616442voile_s
wailers103916812wailers
woolers104214022woolers
yodlers11298922yodlers
yowlers13328922yowlers

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 Filter1786911076711.266141146.1
2DLD Change Limit1076711097.54614268.6
3Display Results1091090.0303633.3
 (SQL Overall)1786911098.84220209.3
 
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.