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

304 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
airlines831279(None) 
airline7315031airline_
airliner836951airliner
airliners945981airliners
hairlines1237131hairlines
aiblins9311472aiblin_s
airiness8412212air_iness
airings83913842air_ings
airlifts1143632airlifts
airlike11310332airlike_
airplanes1187232airplanes
airtimes1037502airtimes
alines65735222a__lines
anilines8415142anilines
arsines73518812a_rsines
berlines102315452berlines
birlings11359612birlings
carlines103521642carlines
girlies83013702girli_es
hairline1137872hairline_
hiplines13310592hiplines
mainlines1138512mainlines
marlines103818712marlines
midlines112613332midlines
millines102718062millines
purlines103514052purlines
abalones1038753abalones
ablings1038743a_blings
ablins8316193a_blin_s
acarines10314343acarines
acridines1247723acridines
adenines9310193adenines
aeries64737783aer_i_es
aerolites9312583aerolites
affines1339483a_ffines
ailing74331013ai_lin_g
aiolis6316843aioli__s
airbuses1067073airbuses
airdates939723airdates
airfares1146693airfares
airholes1138033airholes
airier64619363air_i_er
airiest74221013air_i_est
airing74927503air_in_g
airless73712043airl_ess
airlift1048583airli_ft
airlifted1343193airlifted
airns55521033air__n_s
airplane1067793airplane_
airtime948063airtime_
airting83616303airtin_g
airwaves1444723airwaves
airwise1036713airwise_
aisles64721143aisl__es
alanines8314803alanines
alexines15258503alexines
aliens65619213a__liens
aline57243153a__line_
alined75221403a__lined
aliner65621983a__liner
aliners74717723a__liners
alkines114415733a_lkines
allies63827673a_lli_es
alpines94016193a_lpines
alumines10411683alumines
amidines113010853amidines
amines84727983a__mines
ammines11312673a_mmines
amylenes13105703amylenes
anglings10228273anglings
aniline7418473aniline_
anilins7416793anilin_s
anticlines1249363anticlines
aplites9314933a_plites
apolunes1045293apolunes
applies11311213appli_es
archines133815253archines
arcsines104010343arcsines
arenes64928393a_r_enes
arises65233803a_r_ises
arles56735743a_rl__es
armies85123693a_rmi_es
armings103811503a_rmings
aroints7313133a_roints
arrises71617583a_rrises
arrives101311513a_rrives
arsine64021043a_rsine_
artiness81615403a_rtiness
atrazines1846683atrazines
atropines1148883atropines
azines155517073a__zines
bailies94120203bai_li_es
balklines1536743balklines
baselines1138603baselines
beelines103312803beelines
berline93716853berline_
berlins93216013berlin_s
bialies93618413biali_es
billies93923503billi_es
billings113412633billings
biplanes1238573biplanes
birdies104016213birdi_es
birdings12378823birdings
birdlimes1443093birdlimes
birkies133712433birki_es
birles84920643birl__es
birling104317053birlin_g
bowlines133211623bowlines
brines85028853_br_ines
burliness1137833burliness
bylines1239243_bylines
carbines123617533carbines
carline93923613carline_
carlings114015853carlings
carlins93921913carlin_s
carmines123617863carmines
cholines132214493cholines
cilices113814023ci_lices
citrines102513133citrines
clines84926043__clines
curliness1138553curliness
curlings114110383curlings
cutlines102413273cutlines
dailies84219263dai_li_es
dailiness1038673dai_liness
dairies84217733dair_i_es
dairyings1442633dairyings
darlings103710383darlings
datelines1088853datelines
declines113315803declines
dialings10329823dialings
diamines11311643diamines
diazines1838713diazines
diclinies1247833diclinies
dillies84122163dilli_es
dirling93316073dirlin_g
dirties83119383dirti_es
dirtiness1039473dirtiness
dislikes132810843dislikes
divines113514723di_vines
earliness939693earliness
ermines9416673_ermines
errhines1136413errhines
failings123811013fai_lings
fairies103516043fair_i_es
fairings12388193fair_ings
felines104718073_felines
ferlies103216693ferli_es
figulines1345043figulines
filings115213073fi_lings
fillies103420253filli_es
fillings122910503fillings
firings114112333fir_ings
firkins1437663firkin_s
fishlines15246843fishlines
gantlines1039333gantlines
gasolines1047483gasolines
gillies84120963gilli_es
girlie73711463girli_e_
girlier8289523girli_er
girliest93010403girli_est
gumlines11238573gumlines
guylines12236943guylines
hairiness1238013hair_iness
hairlike1536673hairlike_
hairpins1365433hairpin_s
harmines132715143harmines
hemlines13310623hemlines
heroines112916573heroines
hilliness1248923hilliness
hipline12311423hipline_
hircine1239143hircine_
hirelings1365763hirelings
hotlines11811643hotlines
hurlies103315333hurli_es
hurlings12388213hurlings
hyalines14169333hyalines
illites72415013_illites
imines84918353_i_mines
inclines10313143inclines
intines7921113_intines
iodines83616633_iodines
iolites73819483_iolites
irides74519123_ir_ides
irises64221173_ir_ises
irones64724013_ir_ones
ironies7517423_ironies
isolines8312303isolines
jawlines18126363jawlines
kaolines1239293kaolines
killies113318113killi_es
killings133710483killings
kitlings13318103kitlings
landlines1039763landlines
lanolines939983lanolines
latrines8515003latr_ines
lifelines12147053lifelines
ligroines1044993ligroines
lilies63021413li_li_es
lines57054573___lines
mailings113011923mai_lings
mainline1039863mainline_
mainlined1254353mainlined
mainliner1144673mainliner
mainliners1244003mainliners
malines93625603_malines
marines93928013mar_ines
marline93320953marline_
marlings113713493marlings
marlins93420473marlin_s
marlites103415263marlites
merlins93015813merlin_s
midline102315103midline_
midlives14287463midlives
migraines1286933migraines
millimes122411373millimes
milline92519113milline_
milliner102811863milliner
milliners11289953milliners
millings113712583millings
miriness10310463mir_iness
mirins83918903mir_in_s
mislies92922283misli_es
mislikes143311833mislikes
mislives132912153mislives
moraines10314363moraines
murines93718223mur_ines
myelines1337123myelines
nervines112310463nervines
oiliness8311563oi_liness
opalines10311423opalines
ordines83014903_ordines
orpines94414793_orpines
outlines82418093outlines
pairings11398313pair_ings
perlites10316353perlites
picolines1339623picolines
pilings103313613pi_lings
pipelines13178353pipelines
potlines10714213potlines
pralines102217723pralines
primines123013703primines
prolines102619693prolines
purines94420763pur_ines
purline93516533purline_
purlings113910283purlings
purlins93415423purlin_s
railings93412153rai_lings
ratlines83815293ratlines
reclines103718543reclines
redlines93916083redlines
relines75331323_relines
riflings12227303riflings
sailings93513253sai_lings
salines74029413_salines
sardines92815563sardines
serines74229543ser_ines
setlines8312743setlines
shrines104618693shr_ines
siblings11108123siblings
sidelines10109683sidelines
silanes72517163si_lanes
sillies73425083silli_es
silliness9510363silliness
simlins9311843simlin_s
sirloins836723sirloin_s
skylines1535703skylines
sordines92414073sordines
splines94718893_splines
sublines10315783sublines
surliness939943surliness
tacrines10310563tacr_ines
taglines92210833taglines
tailings93211673tai_lings
tapelines1138463tapelines
taurines8310553taur_ines
terrines82117553terrines
tilings84212793ti_lings
tillites8312833tillites
timelines1148443timelines
tirling83315733tirlin_g
toplines102412563toplines
towlines112610343towlines
trines64132563_tr_ines
turbines1039903turbines
uridines989513uridines
urines64724123_ur_ines
valines104520213_valines
vaselines1246713vaselines
versines112213823versines
violins10311453violin_s
violones1137383violones
virgins1137863virgin_s
virilizes2146953virilizes
vitrines112610913vitrines
waistlines1343893waistlines
waterlines1348953waterlines
whirlies14167373whirli_es
wiliness1139113wi_liness
willies103920153willi_es
wiriness1138953wir_iness
wirings113910113wir_ings
witlings12328443witlings
zibelines2045733zibelines

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623046.72021750.3
3Display Results3043040.1262412.7
 (SQL Overall)1786913047.00225520.0
 
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.