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

408 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
airline731503(None) 
airlike11310331airlike
airliner836951airliner
airlines8312791airlines
hairline1137871hairline
aiblins9311472aiblins
ailing74331012ai_ling
airing74927502air_ing
airlift1048582airlift
airliners945982airliners
airplane1067792airplane
airtime948062airtime
airting83616302airting
airwise1036712airwise
aline57243152a__line
aniline7418472aniline
arsine64021042a_rsine
berline93716852berline
birling104317052birling
carline93923612carline
dirling93316072dirling
girlie73711462girli_e
hairlike1536672hairlike
hairlines1237132hairlines
hipline12311422hipline
hircine1239142hircine
mainline1039862mainline
marline93320952marline
midline102315102midline
milline92519112milline
purline93516532purline
tirling83315732tirling
abalone938903abalone
ablins8316193a_blins
acarine9316003acarine
acauline1046903acauline
acridine1139553acridine
addling10229833addling
adenine8311213adenine
aedine73218393a_edine
aerie54634603aer_i_e
aerolite8315053aerolite
affine12310503a_ffine
aiding84423613ai_ding
aiming94320843ai_ming
aioli5318313aioli__
aiolis6316843aioli_s
airborne1044513airborne
airdate8311323airdate
airfare1047243airfare
airhole1048273airhole
airier64619363air_ier
airily93014823air_ily
airiness8412213air_iness
airings83913843air_ings
airless73712043airless
airlifted1343193airlifted
airlifts1143633airlifts
airman82414223airman_
airmen82612353airmen_
airn46433833air__n_
airns55521033air__ns
airplanes1187233airplanes
airsick1395333airsick
airthing12297953airthing
airtimes1037503airtimes
airwave1344433airwave
aisle55223193aisl__e
alane56135613a__lane
alanine7316863alanine
alexine142410543alexine
alien56425583a__lien
alike95523963a__like
alined75221403a__lined
aliner65621983a__liner
alines65735223a__lines
alive85722513a__live
alkaline12168283alkaline
alkine104916803a_lkine
alone55732963a__lone
alpine84417373a_lpine
alumine9412693alumine
alvine94614583a_lvine
ambling121411793ambling
amidine103613853amidine
amine75835383a__mine
ammine10314493a_mmine
amylene12106883amylene
aneling82719503aneling
anglice1089213anglice
angling92816043angling
anguine839913anguine
anilin6417793anilin_
anilines8415143anilines
anilins7416793anilins
ankling122912063ankling
anticline11410703anticline
antlike11312073antlike
apelike13310533apelike
aplite8316393a_plite
apolune945283apolune
aquiline1746873aquiline
arcane81216743a_rcane
archine125817053archine
arcing95819643a_rcing
arcsine94512393arcsine
arene55329413a_r_ene
argling92812733argling
arise56436433a_r_ise
arising83619973arising
arming94719803a_rming
armlike1348553armlike
aroint6328153a_roint
arrive91311793a_rrive
arsines73518813a_rsines
arsino64113513a_rsino
asinine7310723asinine
asslike1137373asslike
atrazine1748403atrazine
atropine10410113atropine
axlike17388853a_xlike
azine146721413a__zine
baculine1238983baculine
bailie83818363bai_li_e
bailing103723523bai_ling
balkline1437973balkline
baseline10310753baseline
beeline93314723beeline
berlin83116373berlin_
berlines102315453berlines
berlins93216013berlins
beryline1337083beryline
biblike1536893biblike
billie85019173billi_e
billing103823853billing
biplane1139033biplane
birdie94013783birdi_e
birding114014923birding
birdlife1443483birdlife
birdlike1535233birdlike
birdlime1343563birdlime
birkie124110133birki_e
birle75023633birl__e
birlings11359613birlings
birring103713063birring
bowline123613113bowline
brine75132273_br_ine
burling104421133burling
byline11311643_byline
byrling13337373byrling
caprine11314233capr_ine
carbine112918643carbine
carlin84421823carlin_
carlines103521643carlines
carling103727063carling
carlins93921913carlins
carmine112918483carmine
cauline92215603cauline
cervine122610803cervine
choline122915383choline
cilice103213353ci_lice
circling1338423circling
citrine92514023citrine
cline76428533__cline
corvine122113643corvine
crimine112413473crimine
curling104320183curling
cutline92914543cutline
dairying1336353dairying
darling93418363darling
dateline9810353dateline
decline103716613decline
dialing94318173dialing
diamine10311983diamine
diazine1738933diazine
dicliny1337673dicliny
dirking133812603dirking
dislike122913453dislike
divine103514463di_vine
ermine8416923_ermine
errhine1036593errhine
failing113521333fai_ling
fairing113614013fair_ing
fairylike1942693fairylike
feline94820143_feline
ferine96422583fer_ine
ferlie92814053ferli_e
figuline1256033figuline
filing103823763fi_ling
filling113520803filling
finlike14279063finlike
firing104021723fir_ing
firkin1337823firkin_
firkins1437663firkins
firming132811223firming
fishline14237583fishline
furling114016563furling
gantline9410903gantline
gasoline938523gasoline
gillie74816943gilli_e
gilling93520383gilling
girding103611883girding
girdling1146823girdling
girlier8289523girlier
girlies83013703girlies
girlish1137193girlish
girning93210693girning
girting93113333girting
gumline102810113gumline
guyline11258173guyline
hailing113820693hai_ling
hairpin1245413hairpin_
hairpins1365433hairpins
hardline12310273hardline
harmine122816193harmine
hemline12311073hemline
heroine103517483heroine
hilling113821773hilling
hiplike1637603hiplike
hiplines13310593hiplines
hireling121210993hireling
hiring104421603hir_ing
hirpling1467223hirpling
hirsling1277543hirsling
hotline10712353hotline
hurling113616413hurling
hyaline132310723hyaline
idling8912883_idling
illite63414923_illite
imine75821063_i_mine
incline9314643incline
intine61021983_intine
iodine74618653_iodine
iolite63221983_iolite
iring66025423_ir_ing
irking114611753_irking
irone55126363_ir_one
isling71213883_isling
isoline7314013isoline
jailing153415843jai_ling
jawline17137063jawline
jiglike19105333jiglike
kaoline11310143kaoline
kidlike1137063kidlike
killie104114893killi_e
killing123118723killing
kirning12319333kirning
kitling123313573kitling
lairing83715343lair_ing
landline9311443landline
lanoline8311953lanoline
larine63927043lar_ine
latrine7715123latr_ine
lifeline11167663lifeline
ligroine945693ligroine
line46965573___line
liplike1337283liplike
mailing102923343mai_ling
mainlined1254353mainlined
mainliner1144673mainliner
mainlines1138513mainlines
maline84529083_maline
marine84230403mar_ine
marlin84220903marlin_
marlines103818713marlines
marling103322763marling
marlins93420473marlins
marlite92917073marlite
merlin83916683merlin_
merlins93015813merlins
midlife13248303midlife
midlines112613333midlines
migraine1157863migraine
millime112511403millime
milliner102811863milliner
millines102718063millines
milling103223683milling
mirin75023153mir_in_
miring93723803mir_ing
mirins83918903mir_ins
mislie83219153misli_e
mislike132914833mislike
mislive122812693mislive
moline84422033_moline
moraine9314573moraine
murine84220023mur_ine
murrine9411483murrine
myeline1238253myeline
nailing83419963nai_ling
nardine82712573nardine
narine63422553nar_ine
nervine102510633nervine
niblike1336703niblike
nilling83619563nilling
nurling84215823nurling
oarlike113411193oarlike
offline1345783offline
oiling74925313oi_ling
online6315843_online
opaline9412483opaline
orpine83914483_orpine
outline72321333outline
pairing103716733pair_ing
pardine103616723pardine
parling103823763parling
perlite9317323perlite
picoline12310853picoline
piglike14157313piglike
piling95025593pi_ling
pilling103722563pilling
pipeline12149503pipeline
piscine11610973piscine
porcine11312843porcine
potline91015233potline
praline93019743praline
primine113214823primine
proline92321593proline
purine85321893pur_ine
purlin83615863purlin_
purlines103514053purlines
purling103620293purling
purlins93415423purlins
railing83325643rai_ling
ralline73518413ralline
ratline74517803ratline
recline94020493recline
redline84218833redline
reline65434353_reline
riblike1337333riblike
rifling112815013rifling
riling74227973ri_ling
rilling84023623rilling
sailing83927373sai_ling
saline65132703_saline
sardine83317393sardine
serine65432673ser_ine
setline7313923setline
shrine94920053shr_ine
sibling10814423sibling
sideline91011093sideline
sidling9915423sidling
silane62718053si_lane
simlin8311733simlin_
simlins9311843simlins
siring75128313sir_ing
sirloin747593sirloin_
sirloins836723sirloins
skirling13249063skirling
skyline1436793skyline
sordine82515233sordine
spline86020533_spline
stairlike1344753stairlike
subline9316893subline
swirling12249143swirling
tacrine9311293tacr_ine
tagline82412453tagline
tailing82923103tai_ling
taillike1237863taillike
tapeline10310363tapeline
taurine7311363taur_ine
terrine72517573terrine
thirling12248583thirling
tiling73426553ti_ling
tilling83522783tilling
tillite7313563tillite
timeline1039243timeline
tinlike11248803tinlike
tiring74023093tir_ing
titling83715793titling
topline92313183topline
towline102911543towline
trine54734603_tr_ine
turbine9310303turbine
turdine8310283turdine
twirling12246243twirling
uridine81311213uridine
urine55026603_ur_ine
ursine64114123_ursine
vailing113817943vai_ling
valine94623093_valine
vaseline1138613vaseline
versine102515173versine
vialing113614163vialing
violin9311983violin_
violins10311453violins
violone1037153violone
virgin1038083virgin_
virgins1137863virgins
virile9313433vir_ile
virilize2047743virilize
vitrine102511363vitrine
vituline1147093vituline
waiflike1834573waiflike
wailing113620903wai_ling
wairing113414313wair_ing
waistline1244173waistline
warlike142410473warlike
waterline1249653waterline
whirling15237163whirling
wiglike15125853wiglike
wiling103024293wi_ling
willie94116453willi_e
willing113821613willing
wirelike15167493wirelike
wiring104521023wir_ing
witling113215813witling
yirring11307763yirring
zibeline1946363zibeline

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.403443402.0
2DLD Change Limit1340274087.06318975.9
3Display Results4084080.1402914.3
 (SQL Overall)1786914087.60623493.4
 
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.