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

286 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
alevins10211057(None) 
alevin92511511alevin_
alexins141910661alexins
levins94514651_levins
acetins9313172acetins
alanins7315802alanins
aldrins8310202aldrins
alexias14249792alexias
alexin132311482alexin_
alexine142410542alexine
alexines15258502alexines
algins74816432al_gins
aloins65022202al_oins
alumins9512982alumins
alvine94614582al_vine
clevis1158962clevi_s
elevens1066802elevens
elevons1067572elevons
flavins1338542flavins
kelvins14106562kelvins
levies93919862_levies
levin84816412_levin_
levis85818552_levi_s
olefins1037492olefins
oleins6313522ole_ins
abelias93213563abelias
ablins8316193a_blins
acedias1039773acedias
acetin8314693acetin_
actins86321103a_ctins
adenine8311213adenine
adenines9310193adenines
adjoins1585983adjoins
aedine73218393a_edine
aegis6316783a_egi_s
aeons57624653a_e_ons
aeries64737783a_eries
ageing84213403age_ing
ageings9437693age_ings
aiblins9311473aiblins
ailerons849853ailerons
ains46158883a___ins
alanin6317273alanin_
alanine7316863alanine
alanines8314803alanines
alans55636173al__ans
alations82518893alations
albino839933al_bino
albinos937653al_binos
albumins1245353albumins
alcaics1137023alcaics
alcids94812293al_cids
aldrin7311243aldrin_
alecs76620733ale__cs
alefs87319663ale__fs
alegars838933alegars
alembics1442963alembics
alencons1045483alencons
alephs1136533ale_phs
alerting91312383alerting
alerts64418223ale_rts
ales47067103ale___s
aleurons867013aleurons
alewife1344923alewife
alewives1444283alewives
alexia132910463alexi_a
algerine9810283algerine
algerines1069083algerines
algin65718763al_gin_
alias55834603al__ias
alibies9313323alibies
alibis8311073alibi_s
aliening91510893aliening
aliens65619213al_iens
alifs86121263al__ifs
aligns75312953al_igns
aline57243153al__ine
alines65735223al__ines
alining81917043alining
alkies104518093al_kies
alkine104916803al_kine
alkines114415733al_kines
alleging1038473alleging
allergins10146383allergins
alleviant1246143alleviant
alleviants1353413alleviants
allicins1049653allicins
allies63827673al_lies
alluvions1254373alluvions
allying113011663allying
aloin55227423al_oin_
alpine84417373al_pine
alpines94016193al_pines
altering91917113altering
alumin8513543alumin_
alumina9510053alumina
aluminas1048353aluminas
alumine9412693alumine
alumines10411683alumines
amens75624843ame__ns
amidins103713103amidins
amins75534323a__mins
aneling82719503aneling
anemias92512143anemias
aneurins849073aneurins
anilins7416793anilins
anvils9219713a_nvils
aperies9423203aperies
arshins10312573arshins
attains7310983attains
auxins13129813a_uxins
avens86419333a__vens
avians93711563a__vians
avidins11349003avidins
avions94114393a__vions
aweing103911253awe_ing
ayins85321613a__yins
baleens938473bale_ens
begins94415303_begins
bevies114017303_bevies
blains84516373bl_ains
bluefins1345113bluefins
calkins133814873cal_kins
calpains1239763calpains
calving134113503cal_ving
capelins12311133capelins
caseins93115053case_ins
chevies153511443chevies
cleans85817053cle_ans
cleaving141389683cleaving
cleping123310423cleping
clerics1149333clerics
clerids1049093clerids
clevises1336903clevises
clewing13359583clewing
clivias1266693clivias
covins114618063_covins
cretins93216423cretins
delving123711573delving
deveins1138803_deveins
devils104412813_devils
devons104512253_devons
elains64919853el_ains
elegies81312903elegies
elegits8149343elegits
elemis8312383elemi_s
eleven988303eleven_
elevon977953elevon_
elfins94810943el_fins
eloins65419383el_oins
emetins9812643emetins
evens84817103__evens
evils84114263__evils
fadeins1168503fade_ins
flavin1239303flavin_
flavine1338453flavine
flavines1437893flavines
fleeing113511293fleeing
flexing18358993flexing
flexions1844413flexions
fleying14329873fleying
florins10311643florins
galleins9258693galleins
gleans75014743gle_ans
glens66519853gle__ns
gleying12318433gleying
gleyings13283653gleyings
globins10278953globins
gloving12308443gloving
glycins1335563glycins
haemins122811403haemins
halving143511543hal_ving
helving144011133helving
hemins113417563_hemins
jalapins1745623jalapins
javelins18277733javelins
kelvin13117323kelvin_
kevils13358333_kevils
lapins84520683_lapins
lashins103915153lashins
lattins74115483lattins
laving104623573_laving
layins93817653_layins
leans55536253_le_ans
learns65513743_learns
leavens10409303_leavens
leaving114216853_leaving
leavings12407493_leavings
lebens8310093_lebens
lectins92515003_lectins
leggins9259473_leggins
legions84611783_legions
legits71313003_legits
leis45739603_le_i_s
lemans85316393_lemans
lemons84415053_lemons
lenis56326863_leni_s
lens46146493_le__ns
leptins92412693_leptins
lesions73813873_lesions
leucins938103_leucins
levant9314493_levant
levants1037723_levants
levees93714523_levees
levels94113283_levels
levers94621323_levers
levied104111433_levied
levier94013873_levier
leviers103510343_leviers
levity1277903_levity
levulins1144803_levulins
levying1435873_levying
lewis85315843_lewi_s
lexis125916033_lexi_s
linins65922143_linins
lins47059053_l__ins
lipins85016883_lipins
livens94314893_livens
living104318323_living
livings11408923_livings
logins77820643_logins
loins56728423_l_oins
loving104416723_loving
lupins84514463_lupins
lysins94610953_lysins
malkins133311803mal_kins
mavins115119183_mavins
mayvins1535323mayvins
myelins1237353myelins
olefin937583olefin_
olefine1038023olefine
olefines1137323olefines
olein5316003ole_in_
oleine6313793ole_ine
oleines7313393ole_ines
olivine1038843olivine
olivines1137473olivines
paladins11911003paladins
pavins114919663_pavins
peeving135112243peeving
peins76128063_pe_ins
pekins121812233_pekins
pelvics14245643pelvics
pelvis113610323pelvi_s
plains85019593pl_ains
pleons84213343ple_ons
pterins9812993pterins
ramekins1466113ramekins
ravelins113011603ravelins
ravins94622563_ravins
reeving113717663reeving
reins56234563_re_ins
renins64526453_renins
repins84924313_repins
replevins1465203replevins
resins64528773_resins
rewins95020823_rewins
salicins10310933salicins
salvias10279933sal_vias
salving113913153sal_ving
savins93923133_savins
serins64029673_serins
sevens93813663_sevens
sieving112311233sieving
skeins103911903ske_ins
slaving113514833slaving
sleaving123310983sleaving
sleeving12359283sleeving
slewing113311353slewing
slovens10316573slovens
spavins12419323spavins
steins64818343ste_ins
swevens1334613swevens
sylvins13246243sylvins
tameins9311413tame_ins
theins95015423the_ins
tiepins939463tiepins
valerians1245343valerians
valeting1238843valeting
valving14368553val_ving
veins84620493_ve_ins
venins93816703_venins
weevils1384683weevils
welkins1437173welkins
yeelins1038813yeelins
zeins144715393_ze_ins

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.406440125.6
2DLD Change Limit1340272866.64020184.8
3Display Results2862860.1102600.0
 (SQL Overall)1786912867.15624970.8
 
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.