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 “treats” 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
treats6482169(None) 
greats76318391greats
teats55636811t_eats
threats104311671threats
treads74817921treads
treat56240351treat_
treaty94414351treaty
trets55928021tre_ts
areas55935772area_s
arhats9312972arhats
beats76042242_beats
bleats85518612bleats
brats75336012br_ats
breads95419202breads
breaks124816422breaks
breams104815042breams
breast8319632breast
breasts939702breasts
breath113916262breath
breaths124411182breaths
brents84717272brents
cheats114519542cheats
cleats84919312cleats
creaks124315962creaks
creams104715252creams
create85126382create
creates95225202creates
crests85218702crests
derats74625062derats
drats66628372dr_ats
dreads84115022dreads
dreams94513982dreams
drears74614252drears
eats47054872__eats
entreats839772entreats
erects84116182erects
estreats839422estreats
feats86432752_feats
frats86829672fr_ats
freaks134713062freaks
frets85523402fre_ts
great66034242great_
greets75117422greets
groats74816652groats
heats85838402_heats
intreats8311542intreats
meats75034052_meats
neats55931902_neats
oreads73915772oreads
orgeats838352orgeats
peats76140192_peats
pleats85218592pleats
prats76333392pr_ats
preacts113211362preacts
prests84021262prests
rats46260372_r_ats
reacts83616602_reacts
reads64835272_reads
reals55038652_reals
reams75729622_reams
reaps75626192_reaps
rears54739652_rears
reata54225392_reata
reatas64021012_reatas
rents55935182_rents
rests54935872_rests
retreats8311412retreats
rets45352562_re_ts
seats54844342_seats
streaks114411272streaks
streams94713372streams
streets73312612streets
sweats94814612sweats
tats46858132t__ats
teaks94222902t_eaks
teals56234132t_eals
teams75726512t_eams
tears55436462t_ears
teas45851492t_ea_s
teat45963632t_eat_
tents56434212t_ents
terais64023512terais
tests56530192t_ests
tets45847462t_e_ts
texts125515042t_exts
thefts12387922thefts
thetas93011572thetas
threads11419952threads
threaps12488642threaps
threat95020462threat_
throats104612192throats
toeas55726422toea_s
tracts85019072tracts
traits65121982traits
trams75327672tr_ams
trans54933042tr_ans
traps75727482tr_aps
trass56226472tr_ass
trays85623432tr_ays
tread64821702trea_d
treated83618702treated
treater74219832treater
treaters83615842treaters
treaties8316982treaties
treatise8311102treatise
treens65317872treens
trees55835762tre_es
treks96016852tre_ks
trends75513542trends
trepans92311592trepans
tres46542902tre__s
tress55423162tre_ss
tret46653532tre_t_
trevets10499972trevets
trews86118892tre_ws
treys85018212tre_ys
triacs83913222triacs
triads74513532triads
trials64319882trials
troaks104410602troaks
trots56629942tr_ots
trouts66116632trouts
truants738162truants
trusts64714432trusts
trysts9448792trysts
twats86616602t_wats
tweaks1335962tweaks
tweets94210102tweets
ureas55826012urea_s
wheats125013222wheats
wreaks134711112wreaks
wreath124111192wreath
wreaths13338372wreaths
wrests95313082wrests

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.343520965.0
2DLD Change Limit825511342.43633887.9
3Display Results1341340.0462913.0
 (SQL Overall)1786911342.82563253.5
 
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.