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

115 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
alary8612344(None) 
alar46340071alar_
alarm76621421alarm
clary105719611clary
glary96018541glary
salary9515211salary
acari75020282acari
aery77231682a_ery
afar76720782afar_
afars85716512afars
agar58726412agar_
agars66120642agars
aglare7312422aglare
airy75734152a_iry
ajar116217702ajar_
ala312463602ala__
alack114820062alack
alae45643752ala_e
alamo7418142alamo
alan46844082ala_n
aland65526412aland
alane56135612alane
alang66023512alang
alans55636172alans
alant55742292alant
alanyl955482alanyl
alarms85913052alarms
alarum85411982alarum
alas46358122ala_s
alate55340322alate
alert54740652alert
alky115920342al_ky
allay85620392allay
alley85721672alley
alloy85519972alloy
ally76935642al_ly
altar55520642altar_
altars64518152altars
alway116113922alway
ambary134010542ambary
ambry123512102ambry
angary10311322angary
angry9310862angry
apart74330672apart
apery106517902apery
apiary113910382apiary
ariary94114202ariary
array86317142array
ataxy1537312ataxy
aviary12338412aviary
award97118042award
aware86420022aware
away108024222awa_y
aweary1237302aweary
awry107619682a_wry
blare75826232blare
bleary115112552bleary
calory11312842calory
calvary1537182calvary
canary11314692canary
chary135023132chary
claro75018692claro
clay95927412cla_y
datary10310242datary
deary95826842deary
diary95016972diary
flaky155715582flaky
flamy135217472flamy
flare84823632flare
flawy145913382flawy
flaxy189012292flaxy
flay106332802fla_y
galaxy17476312galaxy
glady105413942glady
glairy10448272glairy
glare65222952glare
glazy187410982glazy
glory96413292glory
hoary114516762hoary
laari54415712laari
lacy95829632_lacy
lady86527152_lady
laky116725822_laky
lar37967532_lar_
lard56742002_lard
lardy96119272_lardy
lari45839152_lari
lark85733862_lark
larky125218872_larky
lars46956572_lars
lay68865352_la_y
lazy166423072_lazy
leary85927382leary
lory75931712_lory
malady1237862malady
malar76424442malar_
malarky1645432malarky
malars85020682malars
nary76931222_nary
ovary1149112ovary
palmary14338552palmary
paltry114910402paltry
platy105021662platy
play95928982pla_y
scary105222592scary
slaty86523152slaty
slay76436382sla_y
talar56225382talar_
talars66021682talars
teary85124052teary
unary8315992unary
vagary1337332vagary
vary105226062_vary
wary106740012_wary
weary115620612weary

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 Filter178691538000.300595636.7
2DLD Change Limit538001151.79330005.6
3Display Results1151150.0333484.8
 (SQL Overall)1786911152.12684050.3
 
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.