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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
clean7542041(None) 
clan65633921cl_an
cleans85817051cleans
clear76219051clear
cleat76335061cleat
glean65818201glean
lean46345241_lean
alan46844082al_an
bean66443862_bean
bleak115915382bleak
blear75918682blear
bleat75737002bleat
callan83619602callan
can57760142c__an
cheap126915942cheap
cheat105732452cheat
clad76225822cl_ad
clag75924572cl_ag
clam86332292cl_am
clang86019312cl_ang
clank114719522cl_ank
clans75031012cl_ans
clap86429042cl_ap
claw95624342cl_aw
clay95927412cl_ay
cleaned103512002cleaned
cleaner93712302cleaner
cleanly1236322cleanly
cleanse9358722cleanse
cleanup1144082cleanup
clears84116562clears
cleats84919312cleats
cleave114212512cleave
cleek115514912cleek
clef97028182cle_f
clefs106616242clefs
cleft106222852cleft
clepe94617382clepe
clept95725772clept
clerk115812452clerk
clew95520572cle_w
clews105516332clews
cloak115214012cloak
clon66232482cl_on
clown105214732clown
colead94114642colead
cotan71521782cotan
creak115418432creak
cream95721352cream
cyan96419622c_yan
dean56039482_dean
elan46734242el_an
flan76134182fl_an
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
gleam86916732gleam
gleans75014742gleans
glen56027202gle_n
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
jean116629282_jean
lea37660182_lea_
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
leans55536252_leans
leant56737782_leant
leap66032682_leap
lear47045952_lear
learn55322662_learn
leas45954182_leas
leman75622602_leman
loan47436452_loan
mean65538092_mean
ocean71212962ocean
olea46532722olea_
olein5316002olein
paean77222722paean
pean66147172_pean
plan65833942pl_an
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleat74734472pleat
plena75816392plena
pleon74216382pleon
quean143612842quean
reclean938522reclean
skean94415622skean
spean74620512spean
ulan46527392ul_an
ulpan7310122ulpan
unclean946972unclean
wean75734352_wean
yean75834582_yean

Search took 2 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 Filter178691538000.300595636.7
2DLD Change Limit53800981.39038705.0
3Display Results98980.0303266.7
 (SQL Overall)178691981.720103890.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.