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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
already114426(None) 
bready124511182_bready
leady95618602_l_eady
ready94821502__ready
thready14435902thready
unready11215942unready
abrade9313053abr_ade
abreact11310823abreact
abreast9311283abreast
abroad9310943abroad_
acreage1037843acreage
acred87126353acre_d_
agreed84712503agreed_
ahead96817053a_head_
aired66032923aire_d_
airhead1136993airhead_
airheads1246133airheads
airway1237693airwa_y
alary86123443al__ary
albedo956123albe_do
alcade91111513al_cade
alertly1046793alertly
alfredo1142483alfre_do
alidad838883alidad_
alidade936993alidade
alidads936293alidads
alienly1037503alienly
allay85620393al_la_y
allergy1144503allergy
alley85721673alle__y
almondy13144483almondy
alway116113923al_wa_y
arcade91013643a_rcade
area45843393a_rea__
areae55229743a_rea_e
areal55928733a_rea_l
areally10411243a_really
areas55935773a_rea_s
areaway1335913a_reaway
ariary94114203a_riary
armada938783a_rmada
array86317143a_rra_y
arrear6310253arrea_r
arrears738843arrears
aureate72515283aureate
aweary1237303a_weary
beady114719923__beady
bleary115112553bl_eary
bread85523113_bread_
breads95419203_breads
creaky154911553_creaky
creamy134811363_creamy
creasy114612303_creasy
dread74419023_dread_
dreads84115023_dreads
dreamy12509993_dreamy
dreary104611673_dreary
forelady1545073forelady
freaky16439233_freaky
glady105413943gl__ady
gleamy12398113gl_eamy
greasy10419463_greasy
greedy11518853_greedy
heady125117263__heady
lady86527163_l__ady
lardy96119273lar__dy
lead56038853_l_ead_
leads66028493_l_eads
leafy116316213_l_eafy
leaky125217723_l_eaky
leary85927383_l_eary
leavy115715773_l_eavy
makeready1951553makeready
malady1237863mal__ady
oread64619603_oread_
oreads73915773_oreads
plead85818463pl_ead_
pleads94613953pl_eads
read55942533__read_
readd74617133__readd
reads64835273__reads
reedy910020293__reedy
reread71715433reread_
rereads81512293rereads
screaky16436223screaky
sleazy18267393sl_eazy
spread9312533spread_
spreads1039763spreads
steady103510203_steady
streaky14447813streaky
streamy12509483streamy
thread105011093thread_
threads11419953threads
tread64821703_tread_
treads74817923_treads
treaty94414353_treaty
trendy10469603_trendy
unread73412673unread_

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 Filter1786911340270.406440125.6
2DLD Change Limit134027986.81319672.2
3Display Results98980.0303266.7
 (SQL Overall)178691987.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.