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

142 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
unready1121594(None) 
unread73412671unread_
already1144262already
bready124511182_bready
ready94821502__ready
thready14435902thready
undead82711902undead_
uneasy9278852un_easy
ungreedy1342812ungreedy
unlead73312372unlead_
unleads8228622unleads
unreadily1344342unreadily
unreal64414452unrea_l
unreally1148232unreally
unsteady1243512unsteady
untread857412untread_
untreads936222untreads
untrendy1243482untrendy
unweary1335842unweary
beady114719923__beady
bread85523113_bread_
breads95419203_breads
creaky154911553_creaky
creamy134811363_creamy
creasy114612303_creasy
dread74419023_dread_
dreads84115023_dreads
dreamy12509993_dreamy
dreary104611673_dreary
ennead736253ennead_
enneads834733enneads
entreaty1146173entreaty
forelady1545073forelady
freaky16439233_freaky
funerary1443643funerary
greasy10419463_greasy
greedy11518843_greedy
heady125117263__heady
inroad737933inroad_
inroads837043inroads
knead10429663kn_ead_
kneads11357093kn_eads
leady95618603__leady
neddy10479873_n_eddy
needy94614693_n_eedy
nerdy95014703_n_erdy
oread64619603_oread_
oreads73915773_oreads
outread82811093outread_
outreads9289003outreads
read55942533__read_
readd74617133__readd
reads64835273__reads
reedy910020283__reedy
reread71715433reread_
rereads81512293rereads
screaky16436213screaky
sneaky13427843sn_eaky
spread9312533spread_
spreads1039763spreads
steady103510203_steady
streaky14447813streaky
streamy12509483streamy
sunbeamy1542353sunbeamy
sunray9310123sunr_a_y
thread105011093thread_
threads11419953threads
tread64821703_tread_
treads74817923_treads
treaty94414353_treaty
trendy10469603_trendy
unary8315993un__ary
unbear889163unbea_r
unbears998043unbears
unbend9269773unbend_
unbends10236993unbends
unbred92613303unbre_d_
unchary1537263unchary
unclad938913unclad_
uncrazy2144063uncrazy
uncreate10311353uncreate
underdo937363underdo
undreamt1156543undreamt
undy85015163un___dy
unease63816643un_ease
unfed94614223unfe_d_
unfreed11510123unfreed_
unhandy1445513unhandy
unheard1136943unheard
unibody1343353unibody
unitary1038613unitary
unkend11309223unkend_
unlade72714153un_lade
unlay84613703un_la_y
unleaded10411333unleaded
unlearn735953unlearn
unleash1034963unleash
unled64021073unle_d_
unload73010803unload_
unloads8278523unloads
unmade92911063un_made
unmeant9510903unmeant
unmerry1245023unmerry
unpretty1343263unpretty
unreadier1045013unreadier
unreality1246323unreality
unreason8104483unreason
unreel63612933unre_el
unreels7258313unreels
unreeve10176763unreeve
unrent63219783unre_nt
unrepaid1143713unrepaid
unrepair1042373unrepair
unrest62918853unre_st
unrests7229463unrests
unruly938083unr_uly
unsay83212843un_sa_y
unseal63315473unsea_l
unseals73212573unseals
unseam83313143unsea_m
unseams9338913unseams
unseat64221023unsea_t
unseats73012853unseats
unsexy16296903unse_xy
unteach1246143unteach
unthread1244603unthread_
unthreads1343633unthreads
untidy1059153un_tidy
untreaded1137983untreaded
unwary1239823un_wary
unweave1336363unweave
unwed94114873unwe_d_
unwieldy1542413unwieldy
upreach1444693upreach
uprear8168793uprea_r
uprears9107493uprears
urea46528053u_rea__
ureal56722683u_rea_l
ureas55826013u_rea_s
urease64516993u_rease
uredo65112993u_re_do
ureide7310363u_reide

Search took 7 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.1561145455.1
2DLD Change Limit1340271426.51620568.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.71826598.8
 
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.