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

229 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
airn4643383(None) 
ain37579091ai_n
air38058391air_
airns55521031airns
airs46447421airs
airt45757781airt
airy75734151airy
bairn77515531bairn
cairn75717511cairn
firn76927501firn
girn56026861girn
kirn87123431kirn
pirn67128371pirn
abri65522212abri
acorn75616622acorn
acre67330772acre
adorn64917092adorn
aeon45634612aeon
aero45435342aero
aery77231682aery
afire86215912afire
agin56132712agin
agon56531882agon
ai211288392ai__
aid49269072ai_d
aide56044992aide
aids57846352aids
ail37171042ai_l
ails45654712ails
aim57858212ai_m
aims67738182aims
ains46158882ains
aired66032922aired
airer54927892airer
airing74927502airing
airman82414222airman
airmen82612352airmen
airth85621022airth
airts55626342airts
ais39083572ai_s
ait38093902ai_t
aits46355532aits
akin86328032akin
alan46844082alan
alien56425582alien
align65016502align
amen66733152amen
amin66042252amin
amir65129752amir_
amirs75924922amirs
an211879072a__n
anion55028812anion
anon46134852anon
apian75018332apian
apron7318832apron
ar211379382a_r_
arb510448422a_rb
arc510250902a_rc
are37874572a_re
arf67453372a_rf
aria46245422aria
arid57642712arid
aril45843022aril
ark77044962a_rk
arm58449622a_rm
ars37670932a_rs
art38679142a_rt
aura45836252aura
avian84616052avian
avion84218342avion
awn68035912a_wn
awry107619682awry
axion1211316912axion
axon115524302axon
ayin76331742ayin
azan136521782azan
azon135725052azon
bairns86710872bairns
barn66444642barn
bin56658642bi_n
bird76128322bird
birk106326862birk
birl65830472birl
biro66131212biro
birr66022362birr
born67338412born
brin67038192brin
burn65636422burn
cain65643912cai_n
caird85717232caird
cairns85313302cairns
cairny11557822cairny
carn66245432carn
cion613330912cion
cire65836372cire
corn69945812corn
curn66731882curn
dairy97016302dairy
darn56434622darn
din46459462di_n
dire56644142dire
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
durn56127622durn
earn46737552earn
ern35738352_ern
fain75840562fai_n
fair76332522fair_
fairs85825442fairs
fairy115318282fairy
fern76129322fern
fin66458032fi_n
fir66744892fir_
fire76245592fire
firm96026452firm
firns86018542firns
firs76637712firs
gain56042162gai_n
gien56330022gien
gin46055752gi_n
gird65424992gird
girl56226552girl
girns64516802girns
giro55828632giro
giron66118992giron
girt56646422girt
grin55733722grin
hair76330142hair_
hairs86225172hairs
hairy115316832hairy
hern76134892hern
hin67559562hi_n
hire75538962hire
hisn79620932hisn
horn76735612horn
in28150862_i_n
inn36727432_inn
ion36051022_ion
ire36943172_ire
irk76426362_irk
iron46728462_iron
jin106443932ji_n
jinn115420242jinn
kain85334292kai_n
karn86129412karn
kern85326212kern
kiln85620972kiln
kin76353962ki_n
kir76535672kir_
kirk76221562kirk
kirns95315452kirns
kirs85831732kirs
lain46146282lai_n
lair45934152lair_
laird65417792laird
lairs55425872lairs
lien45339802lien
limn66527692limn
lin37967372li_n
linn46034592linn
lion46334442lion
lira46928682lira
lire47845292lire
liri45128252liri
lorn46435252lorn
main65345512mai_n
mair66133772mair_
mairs76228302mairs
mien65028362mien
mir57046772mir_
mire66748232mire
miri66730372miri
mirin75023152mirin
mirk106729502mirk
mirs66940572mirs
miry96326752miry
morn66237562morn
naira5314742naira
nairu5413812nairu
pain65647242pai_n
pair66031512pair_
pairs75325832pairs
pian66136092pian
pin57066722pi_n
pion67235292pion
pirns76020092pirns
porn65636022porn
rain46251732rai_n
rin36663182ri_n
sain45551292sai_n
sarin55239252sarin
shairn9269062shairn
sign55523052sign
sin36265892si_n
sir35746672sir_
sire46150412sire
siren54525822siren
sirs44338332sirs
sorn46641062sorn
tain45548072tai_n
tarn46842722tarn
tern46134802tern
tin36362172ti_n
tire46143352tire
tirl45029922tirl
tiro46832362tiro
torn46044252torn
turn46330382turn
urn35731462_urn
vain75233002vai_n
vair75624142vair_
vairs85019132vairs
virl76224472virl
wain75840192wai_n
wair75830052wair_
wairs86424062wairs
warn75239322warn
win66456292wi_n
wire75839812wire
wiry106422832wiry
worn75631752worn
yaird96111912yaird
yarn75230042yarn
yin67648732yi_n
yird87018982yird
yirr76513572yirr
zaire14311992zaire
zin125643772zi_n

Search took 4 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.1401276364.3
2DLD Change Limit298722292.70311051.4
3Display Results2292290.1261817.5
 (SQL Overall)1786912292.96960185.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.