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

111 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
clear7621905(None) 
blear75918681blear
clean75420411clean
clears84116561clears
cleat76335061cleat
lear47045951_lear
alar46340072al_ar
alegar739282alegar
altar55520642altar
anear55420322anear
bear66844642_bear
bleak115915382bleak
blears85116452blears
bleary115112552bleary
bleat75737002bleat
caesar8410942caesar
calcar10312752calcar
car59165562c__ar
cedar84014322cedar
cellar84514982cellar
char95132152c_har
cheap126915942cheap
cheat105732452cheat
cheer105420382cheer
cigar8911802cigar
clad76225822cl_ad
clag75924572cl_ag
clam86332292cl_am
clan65633922cl_an
clap86429042cl_ap
claro75018692cl_aro
clary105719612cl_ary
claw95624342cl_aw
clay95927412cl_ay
cleaner93712302cleaner
cleans85817052cleans
cleared103612462cleared
clearer93710822clearer
clearly1236662clearly
cleats84919312cleats
cleave114212512cleave
cleaver124110802cleaver
cleek115514912cleek
clef97028182cle_f
clefs106616242clefs
cleft106222852cleft
clepe94617382clepe
clept95725772clept
clerk115812452clerk
clever114611532clever
clew95520572cle_w
clews105516332clews
cloak115214012cloak
clour76617282clour
colead94114642colead
collar83816172collar
creak115418432creak
cream95721352cream
cymar125711262cymar
czar156013132c_zar
dear55343602_dear
drear65016902drear
ear36867882__ear
fear75337792_fear
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
fleer86020772fleer
gear55934972_gear
gleam86916732gleam
glean65818202glean
hear76143882_hear
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
lar37967532_l_ar
lea37660182_lea_
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
lean46345242_lean
leap66032682_leap
learn55322662_learn
lears55938732_lears
leary85927382_leary
leas45954182_leas
leer46239352_leer
lehr75514942_lehr
liar47229692_liar
near45236502_near
nuclear936232nuclear
olea46532722olea_
pear69745232_pear
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleat74734472pleat
rear45644552_rear
sclera838892sclera
sear47353842_sear
shear85424832shear
smear74416392smear
spear75821062spear
swear85316852swear
tear45242882_tear
ulnar56013982ulnar
unclear936572unclear
velar85817632velar
wear75836722_wear
year76534252_year

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.313570897.8
2DLD Change Limit538001111.43637465.2
3Display Results1111110.0303700.0
 (SQL Overall)1786911111.779100444.6
 
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.