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 “estreats” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
estreats83942(None) 
entreats839771entreats
estreat7314811estreat_
entreat7315262entreat_
entreaty1146172entreaty
escheats1346252escheats
estrays10529402estr_ays
estreated1039562estreated
intreats8311542intreats
mistreats1148632mistreats
retreats8311412retreats
streaks114411272_streaks
streams94713372_streams
streets73312612_streets
treats64821692__treats
astrals75515243astr_als
astricts1049463astricts
bespreads1443503bespreads
besteads11307123best_eads
bestrews1335603bestre_ws
bystreets1442313bystreets
cesareans1143773cesareans
destructs1245773destructs
egrets72712243e_gre_ts
entrants8311753entrants
entraps9109763entr_aps
entreated10310973entreated
entreaties1048113entreaties
entrechats1552893entrechats
entrees71813773entre_es
entremets1147143entremets
entrepots1144253entrepots
entrusts847113entrusts
erects84116183e__rects
escheat12410413escheat_
esprits938393espr_its
estate64719763est__ate
estates74520183est__ates
esteems935243est_eems
esterase849483esterase
esterases949633esterases
esters64627733est_e_rs
estheses1137783estheses
esthesis1148463esthesis
esthete1047433esthe_te
esthetes1147743esthetes
estimate10912003estimate
estimates11911363estimates
estivate111010003estivate
estivates12109753estivates
estral64716513estr_a_l
estray95713333estr_a_y
estreating11710363estreating
estrins7315853estr_ins
estriols856253estriols
estrones8313323estrones
estrous7712533estr_ous
estrual7367933estrua_l
estrums9208603estr_ums
estrus61912113estr__us
estruses838483estruses
extents142610173ext_ents
extracts1747623extracts
extras13310223extr_a_s
extremes1756053extremes
gastreas957263gastrea_s
greats76318393__greats
intreat7416303intreat_
jetstreams1951533jetstreams
kestrels1235813kestre_ls
maltreats1145223maltreats
mistreat10313113mistreat_
nutmeats1044463nutmeats
outeats72215703out_eats
outreads9289003outreads
overeats112415263overeats
overtreats1346643overtreats
postheats1447433postheats
pretreats1146933pretreats
reseats74319583res__eats
respreads1244523respreads
restress82511773restre_ss
restricts1138823restricts
retreads937823retreads
retreat7317533retreat_
screaks13469363_screaks
screams114810623_screams
seats54844343_s__eats
secrets9311773secre_ts
sestets7911473sest_e_ts
sprats85819933_spr_ats
spreads1039763_spreads
starets73515923_stare_ts
stats55933363_st__ats
steads74116223_st_eads
steaks104415853_st_eaks
steals64020063_st_eals
steams84916903_st_eams
stents65019453_st_ents
stets55423913_st_e_ts
stoats65117483_st_oats
straits74916323_straits
straps87721783_str_aps
strass67117223_str_ass
strata63616283_str_ata
stratas73013583_str_atas
strath93216373_str_ath
straths102711723_str_aths
strati63518903_str_ati
stratus73011733_str_atus
straws98718673_str_aws
strays96417933_str_ays
streak104613623_strea_k
streaky14447813_streaky
stream84717293_strea_m
streamy12509483_streamy
streeks11378713_streeks
streels73811343_streels
street64125773_street_
streps86218063_stre_ps
stress66616673_stre_ss
stretta737293_stretta
strettas846423_strettas
strette7310763_strette
stretti747913_stretti
stretto737733_stretto
strettos847113_strettos
strews96817103_stre_ws
striata7379953_striata
striate74218953_striate
striates83417083_striates
strunts7429543_strunts
struts65616803_str_uts
sweats94814613_s_weats
teats55636813__t_eats
threats104311673_threats
treads74817923__treads
treat56240353__treat_
treaty94414353__treaty
trets55928023__tre_ts
untreads936223untreads
vestments1486813vestments
yestreens1243533yestreens

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621436.76621602.4
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.26524596.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.