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

132 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
coilers9361990(None) 
boilers93417061boilers
ceilers93912531ceilers
coalers94419351coalers
coiler84421591coiler_
coiners93620751coiners
coolers93522491coolers
moilers93615201moilers
oilers64721191_oilers
toilers74116261toilers
bailers94221352bailers
boiler84319272boiler_
bowlers123715782bowlers
broilers103210092broilers
cablers114416712cablers
callers94221962callers
cavilers1348112cavilers
ceiler84013962ceiler_
chiders135312942chiders
chiles115425302chile_s
chillers133710922chillers
chimers144515142chimers
cholers124215202cholers
ciders94620092c_iders
citers85022982c_iters
clivers123411752clivers
coaler84121712coaler_
coaters93525792coaters
coaxers164311082coaxers
cobbers134114752cobbers
cobblers14359592cobblers
cobles104622882coble_s
cockers153618332cockers
codders114114452codders
coddlers12359172coddlers
coders95426982co_ders
codgers115113932codgers
coffers154112692coffers
coiled95123942coile_d
coils75030082coil__s
coiner84323782coiner_
coinfers13349502coinfers
cointers103616412cointers
coirs75221052coi__rs
coles76055062co_le_s
coleus86818272co_leus
colies84837052colie_s
collars93816572collars
collets93517902collets
colliers103613582colliers
colors86622372co_lors
colters93522442colters
combers134516622combers
comers105328082co_mers
compilers1537052compilers
confers124120092confers
congers104223232congers
conifers133611702conifers
conkers133721042conkers
conners94023112conners
cooers84324562co_oers
cookers134619462cookers
cooler84824712cooler_
coopers114019482coopers
cooters94525722cooters
copers104629842co_pers
copiers114215962copiers
coppers133519752coppers
copters113621282copters
corders104520882corders
corers85231072co_rers
corkers134118852corkers
corners94723312corners
corulers1039772corulers
coshers123618182coshers
costers94128332costers
cotters94323442cotters
coulees9315512coulees
coulters103614312coulters
couplers123311322couplers
couters93827302couters
covers114627962co_vers
cowers114625532co_wers
coxless1637742coxless
criers83918582cri_ers
cullers93418852cullers
curlers94218072curlers
cutlers94217002cutlers
cyclers1435872cyclers
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
railers74420662railers
recoilers11318152recoilers
rollers73117472rollers
sailers73822322sailers
scowlers13257372scowlers
smilers94113852smilers
spoilers10238632spoilers
tailers73720182tailers
tilers63523502_tilers
toiler63918282toiler_
toiles63923512toile_s
toilets74112912toilets
tollers73217462tollers
toolers74416502toolers
veilers103911822veilers
voicers12348992voicers
voiders11279822voiders
voiles94616442voile_s
wailers103916802wailers
woolers104214022woolers
yodlers11298922yodlers
yowlers13328922yowlers

Search took 5 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 Filter1786911076710.423422437.4
2DLD Change Limit1076711323.57630109.3
3Display Results1321320.0502640.0
 (SQL Overall)1786911324.04944132.1
 
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.