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

238 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
asinine731072(None) 
adenine8311212adenine
alanine7316862alanine
alining81917042alining
amidine103613852amidine
aniline7418472aniline
arginine948562arginine
asininely1242872asininely
oscinine1045532oscinine
quinine163011042quinine
saining83621392saining
abiding11510503abiding
absinthe1342643absinthe
acarine9316003acarine
acini75718983acini__
acinic104713543acini_c
acinose938583acinose
aconite9315473aconite
acridine1139553acridine
actiniae101810013actiniae
actinide11199213actinide
adenines9310193adenines
aedine73218393a_edine
affine12310503a_ffine
agenize172910153agenize
aginner844663agin_ner
agnize16329563a_gnize
agonise83112693agonise
agonize172911403agonize
aiding84423613a_iding
ailing74331013a_iling
aiming94320843a_iming
airing74927503a_iring
airline7315033airline
alanin6317273alanin_
alanines8314803alanines
alanins7315803alanins
alcidine1148233alcidine
alexine142410543alexine
aliening91510893aliening
aligning10158533aligning
aline57243153a__line
alkine104916803a_lkine
alpine84417373a_lpine
alumine9412693alumine
alunite7311633alunite
alvine94614583a_lvine
amandine1148553amandine
amidin94015673amidin_
amidines113010853amidines
amidins103713103amidins
amidone10349313amidone
amine75835383a__mine
aminic104413513amini_c
aminity12310513aminity
ammine10314493a_mmine
anguine839913anguine
anile54634463a__nile
anilin6417793anilin_
anilines8415143anilines
anilins7416793anilins
anime75423203a__nime
anise55129703a__nise
anserine8313093anserine
antimine10714753antimine
aquiline1746873aquiline
archine125817053archine
arcsine94512393arcsine
arenite71017713arenite
arginines1047053arginines
arising83619973arising
arsenide9116333arsenide
arsenite8119663arsenite
arsine64021043a_rsine
ascribe1147743ascribe
ashing107824093as_hing
aside65122083as__ide
asininity1243473asininity
asking116017233as_king
aspire8612123as_pire
aspirin937823aspirin_
aspiring1138873aspiring
aspirins1037733aspirins
asquint16208323asquint
assigning1144673assigning
assize1538633as_size
asslike1137373asslike
astatine8313533astatine
astride8311973astride
astringe938223astringe
atingle848253atingle
atoning83514873atoning
avianize2045723avianize
avidin103510843avidin_
avidins11349003avidins
awning105013393a_wning
azine146721413a__zine
baseline10310753baseline
basinlike1553383basinlike
brining103216473brining
cabining1338643cabining
canine83826703_canine
casimire1244773casimire
casini84615863casini__
cassine93817283cas_sine
chining133316843chining
chinone12510153chinone
coining103920543coining
coniine9316803coniine
conine84528553_conine
cotinine10311493cotinine
crimine112413473crimine
crinite9513633crinite
cuisine9310423cuisine
cyanine122911513cyanine
dining84525133_dining
divine103514463_divine
dwining12269293dwining
eserine7415903eserine
fascine12510583fas_cine
feminine13199783feminine
fining104223213_fining
finite9316823_finite
foining113013453foining
gaining94015663gaining
gasoline938523gasoline
guanine8810543guanine
heinie92512663heini_e
hominine1348913hominine
hyenine1336953hyenine
imine75821063__imine
inane52820343__inane
intine61021983__intine
isatine7311763isatine
isoline7314013isoline
jasmine1636643jas_mine
joining153011483joining
kainite1149543kainite
kinin94917323_kinin_
kinins104014583_kinins
laminin939973laminin_
laminins1039133laminins
latinize17610563latinize
leonine7311233leonine
linin58025523_linin_
lining74526803_lining
linins65922143_linins
mainline1039863mainline
masoning1139763masoning
masonite1049683masonite
meinie82614523meini_e
mining94225453_mining
nine45842173___nine
olivine1038843olivine
opining10311743opining
oscine8311563os_cine
paining103920243paining
patining11312303patining
patinize19610773patinize
pavonine1346663pavonine
peining104619153peining
pennine93712953pennine
pinene82915643_pinene
pining93726533_pining
pinite8321243_pinite
piscine11610973piscine
primine113214823primine
quinin152811953quinin_
quinina16278143quinina
quinines172410203quinines
quinins162811293quinins
quinone16217463quinone
raining83922693raining
ravining12269693ravining
reining84425323reining
resining92919553resining
rosining92411423rosining
ruining83514883ruining
sabine84020393_sabine
sailing83927373sailing
saimin8313663saimin_
saimins9312113saimins
sainting93215733sainting
salicine10311703salicine
saline65132703_saline
salinize1739683salinize
saltine75018563saltine
sanidine939853sanidine
saning75127643_saning
saponine1039223saponine
sardine83317393sardine
savine94220283_savine
seine55732873_s_eine
seining84020773seining
senile63420213_senile
serine65432673_serine
shine85533093_s_hine
shining113816523shining
shrine94920053_shrine
siding83822133_siding
sienite7312713_sienite
signing92713963_signing
silane62718053_silane
simile83115633_simile
since75024173_sin_ce
sine46560623_s__ine
singe65731133_sin_ge
singing93221423_singing
single74520603_single
sinking123320543_sinking
sinned73818413_sin_ned
sinner64320603_sin_ner
sinning83918443_sinning
sinsyne1043303_sinsyne
siping94220633_siping
siring75128313_siring
siting74126623_siting
sizing163616443_sizing
snide64318723_s_nide
snipe75320573_s_nipe
sozine15712353_sozine
spine76534423_s_pine
spline86020533_spline
stanine73417073stanine
stibine938663stibine
supine84216693_supine
swine85625303_s_wine
thionine1187923thionine
tining74927543_tining
trining82919213trining
twining113211443twining
uridine81311213uridine
vaseline1138613vaseline
veining114713893veining
venine93718433_venine
vining104619463_vining
whining143311673whining
wining103625053_wining

Search took 7 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.406440125.6
2DLD Change Limit1340272385.97022450.1
3Display Results2382380.0763131.6
 (SQL Overall)1786912386.45227695.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.