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

199 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
untread85741(None) 
unread73412671un_read
unthread1244601unthread
untreads936221untreads
entreat7315262entreat
intreat7416302intreat
outread82811092outread
retread849002retread
tread64821702__tread
unbred92613302unbre_d
undead82711902un_dead
unfreed11510122unfreed
unlead73312372un_lead
unready11215942un_ready
unreal64414452un_real
unthreads1343632unthreads
untied73720812untie_d
untired82316382untire_d
untreaded1137982untreaded
untreated10312902untreated
untrendy1243482untrendy
untried82615852untried
untrod769852untr_od
uptrend1044292uptrend
antbear935063antbear
anted66328243ant_e_d
anteed75616113ant_eed
antired82316193antire_d
antra56521923antr_a_
antral65719413antr_al
antre55224523antre__
antres65021003antre_s
bread85523113__bread
bunted95219183bunt_e_d
butthead1454513butthead
cathead1338753cathead
centred103411683centre_d
dread74419023__dread
dunted84718503dunt_e_d
ennead736253en_nead
entera64216833entera_
enteral73516443enteral
entered82718883entered
entrap8710563entr_ap
entreated10310973entreated
entreats839773entreats
entreaty1146173entreaty
entree61817883entre_e
entrees71813773entrees
enured73315333enure_d
estreat7314813estreat
fathead1437863fathead
funereal1143943funereal
hatred104814333hatre_d
hothead14349293hothead
hundred1237143hundre_d
hunted104417013hunt_e_d
huntress1144833huntress
inbred93010403inbre_d
inbreed10267643inbreed
inroad737933in_road
instead836203instead
intend72310373int_end
intreated10312663intreated
intreats8311543intreats
intrepid1145363intrepid
inured73114813inure_d
jetbead1742983jetbead
knead10429663kn__ead
laterad8310843laterad
lipread1034953lipread
lunkhead1642963lunkhead
lunted74517523lunt_e_d
lustred8359053lustre_d
metred95315143metre_d
misread10339723misread
mitred94414343mitre_d
nereid7312923_nereid
nutmeat947953nutmeat
nutria639913nutria_
nutrias739813nutrias
nutted74316973nutte_d
onstream1045113onstream
oread64619603__oread
outlead83311103outlead
outreads9289003outreads
pithead13419593pithead
pothead133810393pothead
punted94618713punt_e_d
read55942533___read
reread71715433_reread
rethread1245353rethread
retreads937823retreads
retreat7317533retreat
snared74824553snare_d
snored74819543snore_d
spread9312533_spread
stead65520273_st_ead
streak104613623_streak
stream84717293_stream
subtrend1145193subtrend
tetrad73612053tetr_ad
thread105011093_thread
trad55630913__tr_ad
treads74817923__treads
treat56240353__treat
treed65626733__treed
trend64817453__trend
triad65217723__triad
ultra539363ultr_a_
ultras6310193ultr_as
unaged83916423unage_d
unagreed1036823unagreed
unaired82916013unaire_d
unarmed101811923unarmed
unawed103914903unawe_d
unaxed144113093unaxe_d
unbear889163un_bear
unbend9269773un_bend
unbraid1037183unbraid
unclad938913un_clad
unclean946973unclean
unclear936573unclear
uncreate10311353uncreate
uncreated12312303uncreated
uncrewed1456763uncrewed
uncured10513233uncure_d
undereat9313903undereat
undraw1037813undr_aw
undreamed1336973undreamed
undreamt1156543undreamt
undress838893undress
undrest8313013undrest
undrew1037913undre_w
undried92314613undried
undyed1138143undye_d
unfed94614223un_fe_d
unfired112212453unfire_d
unfree9413203unfre_e
unfrees1048643unfrees
ungreased1136333ungreased
ungreedy1342813ungreedy
unheard1136943un_heard
unhired112512153unhire_d
unideaed1045733unideaed
unideal837103unideal
united74421543unite_d
unkend11309223un_kend
unleads8228623un_leads
unled64021073un_le_d
unload73010803un_load
unmitred1136843unmitre_d
unreel63612933un_reel
unrent63219783un_rent
unrepaid1143713un_repaid
unrest62918853un_rest
unseal63315473un_seal
unseam83313143un_seam
unseat64221023un_seat
unshed10313773unshe_d
unspeak1344793unspeak
unsteady1243513unsteady
unstrap946783unstr_ap
unstress837373unstress
unswear1035003unswear
untamed102913223untamed
untaxed152710583untaxed
unteach1246143unt_each
unthreaded1543533unthreaded
untie54425493untie__
unties64326923untie_s
untimed102713373untimed
untold7149683unt_old
untoward1243193untoward
untraced112413243untraced
untrack1338703untrack
untreading1247563untreading
untrim8310683untr_im
untrims938613untrims
untrue6310773untr_ue
untruer737113untruer
untruest847783untruest
untruly1046293untruly
untruss736553untruss
untruth1045353untruth
untuned82010823untuned
unturned9228563unturned
unurged939143unurged
unused72012883unuse_d
unwed94114873un_we_d
unwrap11126323unwr_ap
uprear8168793u_prear
upstream1243553upstream
uptear896783upt_ear
uptrends1142833uptrends
urea46528063u__rea_
ureal56722683u__real
ureas55826013u__reas
uttered82712433uttered

Search took 9 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271998.01616719.9
3Display Results1991990.0762618.4
 (SQL Overall)1786911998.48221067.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.