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

279 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
aldrin731124(None) 
aldrins8310201aldrins
alanin6317272alanin
alevin92511512alevin
alexin132311482alexin
algin65718762al_gin
aloin55227422al_oin
alumin8513542alumin
baldric12166402baldric
caldron1038152caldron
endrin7312402endrin
florin9312652florin
ladron73413322ladron
abri65522213a_bri_
abris75722603a_bris
acari75020283acari_
acarid95017073acarid
acarine9316003acarine
acetin8314693acetin
acorn75616623acor_n
acrid86920103a_crid
actin74922553a_ctin
adding93914963a_dding
addling10229833addling
adit56443653a_d_it
adjoin14107293adjoin
adman84517903a_dman
admen84516183a_dmen
admit8319493a_dmit
admix1557733a_dmix
adoring9412523adoring
adorn64917093a_dorn
adown95611663a_down
adrift10313113a_drift
adroit7518793a_droit
adzing174110013a_dzing
aedine73218393aed_ine
aerie54634603a_erie
afrit8323173a_frit
again65218123a_gain
agaric93513633agaric
agin56132713a__gin
agria65517143a_gria
aiding84423613aid_ing
aidman92410623aidman
aidmen92610373aidmen
aileron739833aileron
ain37579093a___in
airing74927503a_iring
airn46433833a_ir_n
akin86328033a__kin
alan46844083al__an
alanine7316863alanine
alanins7315803alanins
alar46340073alar__
alarm76621423alar_m
alarming1138583alarming
alarms85913053alarms
alarum85411983alarum
alary86123443alar_y
alation72920553alation
albeit8314343albeit
albino839933al_bino
albumin1145563albumin
alcaic1039983alcaic
alcid85817973al_cid
alder65421913ald_er
alderman1145193alderman
aldermen1145043aldermen
alders74218423alders
aldol61212333ald_ol
aldols7109713aldols
aldose7311093aldose
alert54740653aler_t
alerting91312383alerting
alerts64418223alerts
aleuron757383aleuron
alevins102110573alevins
alexia132910463alexia
alexine142410543alexine
alexins141910663alexins
algerine9810283algerine
algid75415583al_gid
algins74816433al_gins
algoid83011473algoid
alibi7514233alibi_
alibis8311073alibis
alien56425583al_ien
alif76242143al__if
align65016503al_ign
aline57243153al__ine
alining81917043alining
alit46155693al__it
alizarin1745863alizarin
alkalin11178183alkalin
alkie95520033al_kie
alkine104916803al_kine
allergin9136303allergin
allicin949953allicin
alluring939073alluring
allying113011663allying
alodia71112453alodia
aloins65022203al_oins
alpine84417373al_pine
altering91917113altering
alumina9510053alumina
alumine9412693alumine
alumins9512983alumins
alumni856753alumni
alvine94614583al_vine
amain74922913a_main
amidin94015673amidin
amin66042253a__min
amorini9310353amorini
amorino9310253amorino
andiron848283andiron
andro6314163andr_o
android9311513android
andros7313303andros
aneurin749833aneurin
anilin6417793anilin
anuran64313243anuran
anuria6313123anuria
anuric8812103anuric
aporia8315863aporia
apron7318833a_pron
aria46245423a__ria
arid57642713a__rid
aril45843023a__ril
arris56824683a_rris
arshin9312173arshin
asdic83814093asd_ic
aspirin937823aspirin
atria56022343a_tria
atrip75315753a_trip
attain6311753attain
attrit6315753attrit
atwain937813atwain
auding83616933aud_ing
audio62917103aud_io
audit62527883aud_it
auric74521733a_uric
auris55331533a_uris
auxin121411913a_uxin
avidin103510843avidin
ayin76331743a__yin
balding114015063bald_ing
baldrick17153623baldrick
baldrics13164893baldrics
bawdric15164583bawdric
bedrid1039943bedrid
beduin939713beduin
blain75421793bl_ain
blaring104317113blaring
blin67228173bl__in
bodkin1338923bodkin
brin67038193__brin
burin75626063_burin
caldaria1148953caldaria
caldrons1138063caldrons
calkin123515493cal_kin
caloric113413223caloric
calorie92716893calorie
calpain11310413calpain
cauldron1143243cauldron
chaldron1445773chaldron
chlorin123113003chlorin
citrin82615413citrin
clarion9311663clarion
cleric10612133cleric
clerid9312413clerid
codein94916723codein
codlin94516443codlin
dieldrin1093983dieldrin
din46459463__d_in
djin12911633__djin
drain65222893__drain
drib76823263__drib
drink106816383__drink
drip76223953__drip
elain55324703el_ain
eldrich1354583eldrich
elfin84312463el_fin
eloin55923203el_oin
endrins8312163endrins
estrin6315923estrin
fadein1068843fadein
fibrin1138533fibrin
flaring114116803flaring
flavin1239303flavin
florid10311453florid
florins10311643florins
fluorin1037233fluorin
gallein8299043gallein
gastrin839833gastrin
glaring93714883glaring
globin9309723globin
gloria71910543gloria
glycin1235963glycin
grin55733723__grin
hadron102913753hadron
hoddin11369943hoddin
hydria13227903hydria
hydric15227953hydric
hydrid14248973hydrid
indri6310793indri_
indris7311963indris
iodin64419353iod_in
jalapin1645923jalapin
laari54415713laari_
laddie83713173laddie
laden65022193lad_en
lading84227123lad_ing
ladino73615123lad_ino
ladling92813393ladling
ladrone83611873ladrone
ladrons83813193ladrons
ladykin1543963ladykin
lain46146283_l_ain
lairing83715343lairing
lapin75222923_lapin
larding92917873larding
lardon74415063lardon
lari45839153_lari_
larine63927043_larine
laris54737463_laris
latria62313593latria
latrine7715123latrine
lattin64316223lattin
layin84720333_layin
levin84816413_levin
lin37967373_l__in
linin58025523_linin
lipin75518893_lipin
liri45128253_liri_
login66025003_login
loin46838723_l_oin
loran55925093_loran
loris55329153_loris
lorn46435253_lor_n
lupin75215843_lupin
lurid64618973_lurid
luring73820753_luring
lyric104512723_lyric
lysin84512783_lysin
malaria9313693malaria
malarian10311563malarian
malkin122913153mal_kin
mandarin11411023mandarin
mandril1049353mandril
maudlin1037163maudlin
midrib1138243midrib
mirin75023153_mirin
nandin7313033nand_in
olden65114853old_en
oldie6415473old_ie
olefin937583olefin
olein5316003ol_ein
ordain7810403ordain
padri85815173padri_
paladin101011773paladin
pauldron1142473pauldron
pidgin10259813pidgin
plain74823303pl_ain
pterin81014153pterin
purin75527593_purin
redfin10310223redfin
rin36663183___rin
salicin9311223salicin
sarin55239253_sarin
savarin10310003savarin
serin55434443_serin
slain54923573sl_ain
taborin92210453taborin
talaria7412513talaria
tamarin9311913tamarin
valerian1147123valerian
valeric1238303valeric
verdin103113023verdin

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162795.51620434.4
3Display Results2792790.0933000.0
 (SQL Overall)1786912795.99929786.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.