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

109 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
cleats8491931(None) 
bleats85518611bleats
cheats114519541cheats
cleans85817051cleans
clears84116561clears
cleat76335061cleat_
clefts114610161clefts
pleats85218591pleats
alerts64418222alerts
beats76042242_beats
blats75132502bl_ats
bleaks125112432bleaks
blears85116452blears
bleat75737002bleat_
blets75324942ble_ts
bloats85215762bloats
carats85929022carats
cats66356342c__ats
caveats1239802caveats
celts75325782c_elts
cents74730332c_ents
chats105730092c_hats
cheaps134613682cheaps
cheat105732452cheat_
cherts115617232cherts
chests114916262chests
clads85722732cl_ads
clags85621122cl_ags
clams95127672cl_ams
clans75031012cl_ans
claps95626182cl_aps
class75525482cl_ass
clast76030582cl_ast
clasts84817292clasts
claws106020832cl_aws
clays105521332cl_ays
clean75420412clea_n
cleanse9358722cleanse
clear76219052clea_r
cleated103417842cleated
cleave114212512cleave
cleaves124111622cleaves
cleeks125010542cleeks
clefs106616242cle_fs
cleft106222852cleft_
clematis1248652clematis
clepes104214622clepes
clept95725772clept_
clerks12458842clerks
clevis1158962clevis
clews105516332cle_ws
clients938092clients
clifts11519152clifts
cloaks124411262cloaks
cloots85113692cloots
clots75627642cl_ots
clouts87017202clouts
coats75635002c_oats
coleads102911422coleads
creaks124315962creaks
creams104715252creams
create85126382create
creates95225202creates
crests85218702crests
culets85518512cule_ts
eats47054872__eats
eclats8313032ecl_ats
elects83315002elects
feats86432752_feats
flats86429742fl_ats
fleams115011942fleams
fleas86423662flea_s
fleets96915062fleets
floats96816252floats
gleams94812252gleams
gleans75014742gleans
gleets75315052gleets
gloats74515422gloats
greats76318392greats
heats85838402_heats
lats45962702_l_ats
leads66028492_leads
leafs85721182_leafs
leaks95923912_leaks
leans55536252_leans
leaps75522932_leaps
lears55938732_lears
leas45954182_lea_s
least56134882_least
leasts64616412_leasts
leets54927122_leets
lefts86517812_lefts
lets47147942_le_ts
meats75034052_meats
neats55931902_neats
oleate6318882oleate
oleates7417832oleates
peats76140192_peats
plats75531372pl_ats
pleads94613952pleads
pleas75627032plea_s
pleat74734472pleat_
seats54844342_seats
slats55436902sl_ats
sleets64318872sleets
sweats94814612sweats
teats55636812_teats
treats64821692treats
wheats125013222wheats

Search took 3 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 Filter178691825510.1061685764.2
2DLD Change Limit825511092.69030688.1
3Display Results1091090.0303633.3
 (SQL Overall)1786911092.82663231.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.