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

85 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
cellarers1123650(None) 
cellarer10317921cellarer_
cellarets11246061cellarets
cellared11398792cellare_d
cellaret103713572cellare_t
cellars93713692cella__rs
clearers10349302c_learers
collarets11327332collarets
declarers1236422declarers
allayers11156633_allayers
allurers8286773_allurers
bearers94619593be__arers
belayers13298143be_layers
bellowers14177623bellowers
callers94221963call__ers
callipers1356493callipers
carers85133963c___arers
ceilers93912533ceil__ers
cellae84915933cella_e__
cellar84514983cella__r_
cellarage1243563cellarage
cellarages1343463cellarages
cellarette1252483cellarette
cellarettes1352163cellarettes
cellaring1238523cellaring
cellarway1752193cellarway
cellarways1851823cellarways
cellmates1347513cellmate_s
cellulars1144133cellulars
cellules1036813cellule_s
censurers11256073censurers
centares102913893centare_s
clarets94111103c__larets
clavers124314903c__lavers
clawers123910973c__lawers
cleaners103610543c_leaners
clearer93710823c_learer_
cleavers13398873c_leavers
coleaders1237823coleaders
collagens12256033collagens
collages113514243collage_s
collards113310193collar_ds
collared113211143collare_d
collaret103116703collare_t
collarless1243073collarless
collars93816573colla__rs
collates103019143collate_s
collators11410343collators
collegers12256843collegers
colliders12298073colliders
colliers103613583coll_iers
colluders12285613colluders
colorers10312183c_olorers
colourers1136473colourers
comparers15319393comparers
cullers93418853cull__ers
declarer1148063declarer_
declares11611313declare_s
deflaters13298703deflaters
delayers12268663de_layers
deplorers1245463deplorers
elaters74420193_e_laters
enlargers1043493_enlargers
fearers104815273fe__arers
fellates11312753fellate_s
fellators1247143fellators
fellers104117543fell__ers
hearers104319783he__arers
hellers103619833hell__ers
pillagers12276923pillagers
rearers74323563re__arers
relaters83218153re_laters
relaxers15298263re_laxers
releasers937323releasers
reloaders1036423reloaders
replacers13266833replacers
seafarers1244143seafarers
sellers73721313sell__ers
tearers75218233te__arers
tellers73717593tell__ers
villagers13296153villagers
wearers104615903we__arers
welfares1445543welfare_s
welldoers1343193welldoers
yellers103912953yell__ers

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 Filter1786911486410.406440125.6
2DLD Change Limit148641857.83018983.5
3Display Results85850.0302833.3
 (SQL Overall)178691858.26621617.6
 
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.