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

116 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
cheats11451954(None) 
chats105730091ch_ats
cheaps134613681cheaps
cheat105732451cheat_
cherts115617231cherts
chests114916261chests
cleats84919311cleats
heats85838401_heats
wheats125013221wheats
beats76042242_beats
bleats85518612bleats
carats85929022carats
cats66356342c__ats
caveats1239802caveats
celts75325782c_elts
cents74730332c_ents
chads116122232ch_ads
chaeta11310682chaeta
chais107530312ch_ais
chams126028502ch_ams
chants115020392chants
chaos105622862ch_aos
chaps125326062ch_aps
chars105936642ch_ars
charts115823092charts
chat95546132ch_at_
chaws135022462ch_aws
chays135319742ch_ays
cheap126915942chea_p
cheapo134810082cheapo
cheapos14418512cheapos
cheated134416342cheated
cheater124816962cheater
cheaters133613512cheaters
checks174912702checks
cheeks154712782cheeks
cheeps135312912cheeps
cheers114518912cheers
chefs136214662che_fs
chelas113817202chelas
chelate122914892chelate
chelates132713842chelates
chemos13311722chemos
chert105232102chert_
cherty144612472cherty
chess105016922che_ss
chest104926142chest_
chesty144610502chesty
chetah14399582chetah
chetahs15347072chetahs
cheth135013822che_th
cheths14389822cheths
chews135418512che_ws
chias104625522chia_s
chiaus113611312chiaus
chints115117832chints
chits105424572ch_its
chotts113610992chotts
cleans85817052cleans
clears84116562clears
cleat76335062cleat_
clefts114610162clefts
coats75635002c_oats
coheads13289232coheads
creaks124315962creaks
creams104715252creams
create85126382create
creates95225202creates
crests85218702crests
eats47054872__eats
escheats1346252escheats
feats86432752_feats
ghats95818612gh_ats
greats76318392greats
haets86525122_haets
hats76858252_h_ats
heads95127112_heads
heals85733452_heals
heaps105223222_heaps
hears86737372_hears
hearts96218942_hearts
heat77061422_heat_
heath115724282_heath
heaths126316382_heaths
hefts116218152_hefts
hents87330742_hents
hests85829932_hests
hets75547202_he_ts
khats125316012kh_ats
khets124913432khe_ts
meats75034052_meats
neats55931902_neats
peats76140192_peats
pleats85218592pleats
recheats1339192recheats
reheats104513522reheats
rheas84816952rhea_s
seats54844342_seats
sheafs124912882sheafs
sheals94420642sheals
shears93820902shears
sheas86331792shea_s
sheath12412892sheath
sheaths1358752sheaths
sheets93918502sheets
shoats94117082shoats
sweats94814612sweats
teats55636812_teats
thefts12387922thefts
thetas93011572thetas
threats104311672threats
treats64821692treats
whats117718992wh_ats
wheals124512522wheals
wheat114924572wheat_
whets115019612whe_ts

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.350510545.7
2DLD Change Limit825511162.45033694.3
3Display Results1161160.0363222.2
 (SQL Overall)1786911162.83663008.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.