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

132 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
airliner83695(None) 
airline7315031airline_
airliners945981airliners
airlines8312791airlines
airier64619362air_i_er
airlike11310332airlike_
aliner65621982a__liner
girlier8289522girli_er
hairline1137872hairline_
hairlines1237132hairlines
mainliner1144672mainliner
milliner102811862milliner
acrider1038623acr_ider
adroiter946193adroiter
aerier64823153aer_i_er
aiblins9311473aiblin_s
ailing74331013ai_lin_g
airer54927893air___er
airiness8412213air_iness
airing74927503air_in_g
airings83913843air_ings
airlift1048583airli_ft
airlifted1343193airlifted
airlifts1143633airlifts
airplane1067793airplane_
airplanes1187233airplanes
airpower1343983airpower
airtime948063airtime_
airtimes1037503airtimes
airting83616303airtin_g
airwise1036713airwise_
aliener71011193a__liener
aligner8108313a__ligner
aline57243153a__line_
alined75221403a__lined
aliners74717723a__liners
alines65735223a__lines
almner85710723a__lmner
aniline7418473aniline_
anilines8415143anilines
applier1137903appli_er
arbiter939933a_rbiter
arider74717743a_r_ider
armiger1036253a_rmiger
arraigner1092973arraigner
arriver10117793a_rriver
arsine64021043a_rsine_
arsines73518813a_rsines
artier63419733a_rti_er
atelier7311623ateli_er
attainer8116913attainer
bairnlier1142233bairnli_er
baseliner1144743baseliner
berline93716853berline_
berlines102315453berlines
bilinear1044043bi_linear
birler85715083birl__er
birling104317053birlin_g
birlings11359613birlings
briner84519043_br_iner
burlier93514413burli_er
byliner1235723_byliner
carline93923613carline_
carlines103521653carlines
curlier93314183curli_er
decliner113710843decliner
dirling93316073dirlin_g
dirtier83312093dirti_er
disliker13358643disliker
diviner11369883di_viner
drainer83012843_drainer
earlier72612743earli_er
eyeliner1174893eyeliner
firrier103410133firri_er
furriner11267303furriner
gainlier965673gainli_er
girlie73711463girli_e_
girlies83013703girli_es
grainer83714063_grainer
hairier103111053hair_i_er
hairlike1536673hairlike_
hillier103413963hilli_er
hipline12311423hipline_
hiplines13310593hiplines
hircine1239143hircine_
incliner1038513incliner
inlier63615363_inli_er
ironer64216453_ir_oner
jetliner1534853jetliner
liner55938923___liner
loriner7511893lor_iner
mainline1039863mainline_
mainlined1254353mainlined
mainliners1244003mainliners
mainlines1138513mainlines
mariner93315993mar_iner
marlier92614773marli_er
marline93320953marline_
marlines103818713marlines
midlifer14215793midlifer
midline102315103midline_
midlines112613333midlines
millier93716703milli_er
milline92519113milline_
milliners11289953milliners
millinery14336103millinery
millines102718063millines
mirier83918363mir_i_er
mirkier13319053mirki_er
misliker14319573misliker
oilier64417233oi_li_er
outliner82412113outliner
pilsner935343pi_lsner
purline93516533purline_
purlines103514053purlines
purloiner1143263purloiner
recliner103211913recliner
redliner93510473redliner
ruiner64013643__ruiner
sideliner10126013sideliner
sillier74017593silli_er
strainer8512223strainer
surlier72915443surli_er
swirlier1135213swirli_er
tirling83315733tirlin_g
trainer73316793_trainer
trilinear943173trilinear
twirlier1133513twirli_er
whirlier14175293whirli_er
wilier93217073wi_li_er
willinger1343723willinger
wirier94215553wir_i_er

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.406440125.6
2DLD Change Limit1461621327.17320376.7
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.62523434.9
 
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.