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

357 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
aniline741847(None) 
anilin6417791anilin_
anilines8415141anilines
anilins7416791anilins
ailing74331012a_iling
airline7315032airline
aline57243152a__line
amidine103613852amidine
aneling82719502aneling
anglice1089212anglice
angling92816042angling
anguine839912anguine
anile54634462anil__e
anility10312722anility
ankling122912062ankling
anticline11410702anticline
antilife11410432antilife
antimine10714752antimine
antlike11312072antlike
anviling1239742anviling
aquiline1746872aquiline
asinine7310722asinine
gantline9410902gantline
incline9314642incline
landline9311442landline
lanoline8311952lanoline
mainline1039862mainline
nailing83419962nailing
online6315842on_line
sanidine939852sanidine
abalone938903abalone
abiding11510503abiding
ability12311443ability
ablins8316193a_blins
acarine9316003acarine
acauline1046903acauline
acridine1139553acridine
addling10229833addling
adenine8311213adenine
aedine73218393a_edine
affine12310503a_ffine
agile65122263agil__e
agility1148653agility
agnizing1936833agnizing
aiblins9311473aiblins
aiding84423613a_iding
aiming94320843a_iming
airing74927503a_iring
airlike11310333airlike
airliner836953airliner
airlines8312793airlines
alane56135613a__lane
alanine7316863alanine
alcidine1148233alcidine
alexine142410543alexine
alien56425583a__lien
alike95523963a__like
alined75221403a__lined
aliner65621983a__liner
alines65735223a__lines
alining81917043alining
alive85722513a__live
alkaline12168283alkaline
alkine104916803a_lkine
alone55732963a__lone
alpine84417373a_lpine
alumine9412693alumine
alvine94614583a_lvine
ambling121411793ambling
amidin94015673amidin_
amidines113010853amidines
amidins103713103amidins
amidone10349313amidone
amine75835383a__mine
ammine10314493a_mmine
amylene12106883amylene
analcime1245393analcime
analcite1049333analcite
anality10313633anality
analyse10208893analyse
analyte10158813analyte
analyze19167013analyze
ancillae1047653ancillae
ancone83916953an_cone
anele55628833anel__e
anemone9119453anemone
angeling102811733angeling
angina7413133an_gina
angle64528873angl__e
anglings10228273anglings
anil46437433anil___
anilingus1043113anilingus
anilities9516003anilities
anils56326723anil__s
animalize2048553animalize
animate91617213animate
anime75423203an__ime
animi74016663animi__
animis84615943animi_s
animism113510213animism
animist93815173animist
anion55028813ani_on_
anionic9312873anionic
anions64123033ani_ons
anise55129703an__ise
anisic8313793anisi_c
anisole71010833anisole
ankle95220253ankl__e
anlace82513923an_lace
anlage72514233an_lage
anodize1738683anodize
anodyne1144163anodyne
anoint6423633an_oint
anole55330383anol__e
anolyte10159003anolyte
anomie83215963anomi_e
anserine8313083anserine
anteing8312813anteing
antiacne1048583antiacne
antialien9410173antialien
anticlines1249363anticlines
anticling12310693anticling
antielite9411603antielite
antigene9410203antigene
antiking13412073antiking
antilifer1246833antilifer
anting75827023an_ting
antlion7310293antlion
antlions839193antlions
anvilling1336833anvilling
anyone94612733an_yone
anytime1246043anytime
anywise1345203anywise
apelike13310533apelike
aplite8316393a_plite
apolune945283apolune
archine125817053archine
arcsine94512393arcsine
arginine948563arginine
argling92812733argling
arising83619973arising
armlike1348553armlike
arsine64021043a_rsine
asslike1137373asslike
auntlike1234983auntlike
availing1267283availing
avidin103510843avidin_
avidins11349003avidins
axile126020513axil__e
axillae14248233axillae
axlike17388853a_xlike
azine146721413a__zine
baculine1238983baculine
bailie83818363baili_e
bailing103723523bailing
balkline1437973balkline
banalize191010933banalize
bantling112612003bantling
baseline10310753baseline
beeline93314723beeline
berline93716853berline
boiling103819673boiling
bowline123613113bowline
buntline10198063buntline
byline11311643_byline
canaling112016413canaling
canalise10816213canalise
canalize19914493canalize
candling122313873candling
canikin13189753canikin_
canikins14219163canikins
canine83826703can__ine
carline93923613carline
carnitine1178573carnitine
cauline92215603cauline
caviling14310113caviling
ceiling103416723ceiling
choline122915383choline
cilice103213353_cilice
cline76428533__cline
coiling103723453coiling
coniine9316803coni_ine
crimine112413473crimine
cuisine9310423cuisine
cutline92914543cutline
dandling112511733dandling
dangling112611233dangling
dateline9810353dateline
decline103716613decline
divine103514463_divine
eanling81416673ean_ling
enamine91214313enamine
engine71114863en_gine
enisling949633enisling
enplane939723enplane
ensiling9410723ensiling
entwine1039143entwine
exiling15311083exiling
failing113521333failing
fanglike1636823fanglike
fanlike142610503fan_like
fanzine1937123fan_zine
feline94820143_feline
filing103823763_filing
finlike14279063finlike
foiling113317653foiling
gangling112411403gangling
gantlines1039333gantlines
gasoline938523gasoline
guanidine1144043guanidine
guiling93214213guiling
gumline102810113gumline
guyline11258173guyline
hailing113820693hailing
hairline1137873hairline
handlike1639153handlike
handling132312713handling
hardline12310273hardline
heiling113616363heiling
hemline12311073hemline
hipline12311423hipline
hotline10712353hotline
hyaline132310723hyaline
imine75821063__imine
inclined1138643inclined
incliner1038513incliner
inclines10313143inclines
induline939493induline
inklike1037033inklike
inkling122911303inkling
inosine7314273inosine
inquiline1844753inquiline
intine61021983in_tine
intwine1038513intwine
inulin6311733inulin_
inulins7311493inulins
isoline7314013isoline
jailing153415843jailing
jangling17249623jangling
jawline17137063jawline
kaoline11310143kaoline
knifing1536483knifing
landlines1039763landlines
lanolin7310643lanolin_
lanolines939983lanolines
lanolins8310533lanolins
line46965573___line
longline938763longline
mailing102923343mailing
mainlined1254353mainlined
mainliner1144673mainliner
mainlines1138513mainlines
maline84529083_maline
mandoline1248413mandoline
mangling122312623mangling
manikin132110243manikin_
manikins14189723manikins
manille92613273manil_le
manlike133012783man_like
mantling112012613mantling
marline93320953marline
midline102315103midline
milline92519113milline
moiling103417663moiling
moline84422033_moline
myeline1238253myeline
nardine82712573nardine
narine63422553_narine
niblike1336703_niblike
niding83217983_niding
nilling83619563_nilling
nine45842173_n__ine
nixie125114943_nixi_e
nixing143311493_nixing
offline1345783offline
oiling74925313_oiling
olivine1038843olivine
opaline9412483opaline
outline72321333outline
paneling111013623paneling
piling95025593_piling
potline91015233potline
praline93019743praline
primine113214823primine
proline92321593proline
purline93516533purline
quinine163011043quinine
railing83325643railing
ralline73518413ralline
ramilie9310283ramili_e
rankling132610113rankling
ratline74517803ratline
recline94020493recline
redline84218833redline
reline65434353_reline
riling74227973_riling
roiling83220453roiling
sailing83927373sailing
salicine10311703salicine
saline65132703_saline
sandlike1339713sandlike
sandling102214413sandling
sanguine947633sanguine
sanidines1048043sanidines
sanitise81511813sanitise
sanitize171410083sanitize
setline7313923setline
silane62718053_silane
skyline1436793skyline
smiling103915443smiling
snailing92912973snailing
sniping103712053sniping
soiling83422323soiling
spiling102919703spiling
spline86020533_spline
stibine938663stibine
subline9316893subline
syncline1356073syncline
tagline82412453tagline
tailing82923103tailing
tangling101712543tangling
tanklike1136013tanklike
tapeline10310363tapeline
tiling73426553_tiling
tinlike11248803tinlike
toiling83219023toiling
topline92313183topline
towline102911543towline
unalike11311533unalike
undine7817263un_dine
unilineal943923unilineal
unilinear942913unilinear
unisize1647343unisize
uniting8315823uniting
unitive10310563unitive
unitize16310033unitize
unlike102614063un_like
unlined82515803un_lined
unlink104011013un_link
unlive92712333un_live
unpiling1139753unpiling
unsling8313643unsling
untwine1038623untwine
uridine81311213uridine
utilise749063utilise
utilize1648813utilize
vailing113817943vailing
valine94623093_valine
vanillin1145903vanillin_
vanillins1245543vanillins
vaseline1138613vaseline
veiling113615293veiling
wailing113620903wailing
wangling132310993wangling
whiling143511743whiling
wiling103024293_wiling
xanthine1847253xanthine

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.390458182.1
2DLD Change Limit1340273577.26618445.8
3Display Results3573570.1402550.0
 (SQL Overall)1786913577.79622920.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.