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

134 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
clef9702818(None) 
alef76340691alef
chef125125621chef
clefs106616241clefs
cleft106222851cleft
clew95520571clew
ale36572342ale_
alec66430062alec
alee46652322alee
alefs87319662alefs
ales47067102ales
alif76242142alif
beef96233682beef
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
cafe95230322cafe
caff125631672caff
calf96339562calf
calif104929102calif
cee55952702c_ee
cees65941592cees
cel56040552c_el
celeb9314872celeb
cell65031722cell
cels65534972cels
celt65646712celt
cep75736332c_ep
chefs136214662chefs
chew126622132chew
chez184519022chez
chief134419482chief
clad76225822clad
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
claw95624342claw
clay95927412clay
clean75420412clean
clear76219052clear
cleat76335062cleat
cleek115514912cleek
clefts114610162clefts
clepe94617382clepe
clept95725772clept
clerk115812452clerk
clews105516332clews
cliff135917132cliff
clift106422192clift
clip86924002clip
clod76124612clod
clog76123242clog
clon66232482clon
clop86929892clop
clot66542422clot
cloy96623832cloy
club85819472club
clue65324532clue
clued84917682clued
clues74623032clues
coed77140542coed
coff126930782coff
coif96337912coif
cole66956112cole_
coled85540762coled
coles76055062coles
coof96643272coof
corf95941482corf
cred76530882cred
crew96122682crew
cue57544182cue_
cued76329562cued
cues65438982cues
cuff125327992cuff
cuif96529142cuif
culet76040342culet
culex144613932culex
curf97538782curf
def76546722_def
delf85436572delf
ef57345362__ef
elf66138522el_f
fief107331362fief
flea75628492flea
fled85429772fled
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
gled65631142gled
glee55239062glee
gleg66219802gleg
glen56027202glen
gley85724652gley
ilea45931462ilea
ilex115822032ilex
keef115830002keef
kef105639662_kef
kief117128412kief
lea37660182_lea
leaf76441032_leaf
led46254552_led
lee36068142_lee
left76340482_left
leg46446112_leg
lei36846382_lei
lek75640302_lek
les35663072_les
let36481472_let
leu36047402_leu
lev66139422_lev
lex107943822_lex
ley66246812_ley
lez125541312_lez
lief76036992lief
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
pelf97031452pelf
plea66830602plea
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
reef74938212reef
ref66053292_ref
self75138292self
sled55334372sled
slew76228232slew
tref77030992tref
ylem9217892ylem

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 Filter178691298720.343520965.0
2DLD Change Limit298721340.90632971.3
3Display Results1341340.0334060.6
 (SQL Overall)1786911341.282139384.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.