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

213 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
airy7573415(None) 
aery77231681aery
air38058391air_
airn46433831airn
airs46447421airs
airt45757781airt
awry107619681awry
dairy97016301dairy
fairy115318281fairy
hairy115316831hairy
miry96326751miry
wiry106422831wiry
ably99725132ably
abri65522212abri
aby810238062a_by
achy126316092achy
acidy117214892acidy
acre67330772acre
aero45435342aero
afire86215912afire
agly86821802agly
ahoy101919182ahoy
ai211288392ai__
aid49269082ai_d
aide56045002aide
aids57846362aids
ail37171042ai_l
ails45654712ails
aim57858212ai_m
aims67738182aims
ain37579092ai_n
ains46158882ains
aired66032922aired
airer54927892airer
airily93014822airily
airns55521032airns
airth85621022airth
airts55626342airts
airway1237692airway
ais39083572ai_s
ait38093902ai_t
aits46355532aits
alary86123442alary
alky115920342alky
ally76935642ally
ambry123512102ambry
amir65129752amir_
amirs75924922amirs
amity10416092amity
angry9310872angry
any68440492a_ny
apery106517902apery
apiary113910382apiary
ar211379382a_r_
arb510448422a_rb
arc510250902a_rc
are37874572a_re
arf67453372a_rf
aria46245422aria
ariary94114202ariary
arid57642712arid
aril45843022aril
ark77044962a_rk
arm58449622a_rm
army96624182army
array86317142array
ars37670932a_rs
art38679142a_rt
arty77531312arty
aryl75922342a_ryl
ashy107717352ashy
aura45836252aura
aviary12338412aviary
away108024222away
awny105919302awny
ay511773892a__y
bairn77515532bairn
bird76128322bird
birk106326862birk
birl65830472birl
biro66131212biro
birr66022362birr
bury95633592bury
caird85717232caird
cairn75717512cairn
cairny11557822cairny
carry105823782carry
cire65836372cire
city95122622city
cory96941512cory
cry89726242_cry
daily95922332daily
daisy95915312daisy
diary95016972diary
didy99121512didy
dire56644142dire
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
dirty95617802dirty
dory85836232dory
dry76526032_dry
eery76129622eery
eyry106315882eyry
faery116015482faery
fair76332522fair_
fairly125610012fairly
fairs85825442fairs
fiery114714792fiery
fir66744892fir_
fire76245592fire
firm96026452firm
firn76927502firn
firry115713532firry
firs76637712firs
fry96226502_fry
fury107727972fury
gaily95020972gaily
gird65424992gird
girl56226552girl
girly94415292girly
girn56026862girn
giro55828632giro
girt56646422girt
glairy10448272glairy
gory86129662gory
hair76330142hair_
hairs86225172hairs
harry115322952harry
hire75538962hire
icy86322122_icy
ire36943172_ire
irk76426362_irk
ivy96317442_ivy
jivy176213112jivy
jury146719592jury
kaury12429762kaury
kir76535682kir_
kirk76221572kirk
kirn87123442kirn
kirs85831742kirs
lair45934152lair_
laird65417792laird
lairs55425872lairs
laity85318902laity
lily76730182lily
limy95727712limy
liny78141322liny
lira46928682lira
lire47845292lire
liri45128252liri
lory75931712lory
mair66133782mair_
mairs76228302mairs
marry104821692marry
mir57046772mir_
mire66748232mire
miri66730372miri
mirk106729502mirk
mirky146315522mirky
mirs66940572mirs
mity95528212mity
naira5314742naira
nairu5413812nairu
nary76931222nary
nixy145714512nixy
oily77932252oily
pair66031512pair_
pairs75325832pairs
parry105323752parry
pily96132732pily
piny911838352piny
pipy115421512pipy
pirn67128372pirn
pity96031932pity
pixy166117762pixy
pry85728052_pry
rainy85921082rainy
rimy96621282rimy
saury84317222saury
scry96017762scry
sir35746672sir_
sire46150412sire
sirs44338332sirs
sizy164816392sizy
spiry105017352spiry
spry96819122spry
tarry85422512tarry
tidy86822422tidy
tiny76134632tiny
tire46143352tire
tirl45029922tirl
tiro46832362tiro
tivy1014516862tivy
tory75840542tory
try66529672_try
vair75624142vair_
vairs85019132vairs
vary105226062vary
very108025642very
viny106025952viny
virl76224472virl
wair75830052wair_
wairs86424062wairs
wary106740012wary
wily106428812wily
winy107034322winy
wire75839812wire
wry96524702_wry
yaird96111912yaird
yird87018982yird
yirr76513572yirr
zaire14311992zaire

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298722130.95331345.2
3Display Results2132130.0464630.4
 (SQL Overall)1786912131.262141593.5
 
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.