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

252 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
albinos93765(None) 
albino839931albino_
ablings1038742ablings
ablins8316192ablin_s
albedos1075252albedos
albinal937812albinal
albinic1136852albinic
albinism1276412albinism
albites9313202albites
algins74816432algin_s
alines65735222al_ines
aliyos9349532al_iyos
alkines114415732alkines
alnicos985532alnicos
aloins65022202aloin_s
alpines94016192alpines
bambinos1443872bambinos
ladinos8389962ladinos
latinos73613802latinos
linos55631502_l_inos
abides94719893a_bides
abmhos1334973a_bmhos
abos67734413a_b__os
acinose938583a_cinose
acinous9310933a_cinous
acinus8311253a_cinus
actings104512463actings
actinon9459463actinon
actinons10389453actinons
actins86321103actin_s
actions94218513actions
adios65822863a_di_os
affines1339483affines
ageings9437693ageings
agings86312673a_gings
agios65919863a_gi_os
aiblins9311473aiblin_s
aikidos1253883aikidos
ains46158883a__in_s
airings83913843airings
alamos8415003al_amos
alands75418373al_ands
alanines8314803alanines
alanins7315803alanins
alans55636173al_an_s
alants67722023al_ants
alations82518893alations
albas75925393alb__as
albatas938373albatas
albedo956123albedo_
albedoes1184533albedoes
albicore1243703albicore
albicores1343513albicores
albinisms1395773albinisms
albinotic1343633albinotic
albite8313313albi_te
albitic1139133albitic
albizia1864093albizia
albizias1973533albizias
albs68628573alb___s
albuminous1452933albuminous
albumins1245353albumin_s
albumose1272633albumose
albums10198273alb_ums
alburnous1143083alburnous
alcids94812293alci_ds
aldrins8310203aldrin_s
alevins102110573alevin_s
alexines15258503alexines
alexins141910663alexin_s
algin65718763algin__
alias55834603al_i_as
alibies9313323alibies
alibis8311073al_ibis
alienor7116303alienor
alienors8136733alienors
aliens65619213al_iens
alifs86121263al_i_fs
aligns75312953al_igns
aline57243153al_in_e
alined75221403al_ined
aliner65621983al_iner
aliners74717723al_iners
aliyas93911803al_iyas
aliyot93611713al_iyot
alkanes113812933alkanes
alkenes114212753alkenes
alkies104518093alki_es
alkine104916803alkin_e
alkynes14336463alkynes
allies63827673alli_es
alliums957973alliums
almonds10127953almonds
alnico877943alnico_
aloin55227423aloin__
alpine84417373alpin_e
alpinism1286183alpinism
alpinist1059153alpinist
alsikes1137263alsikes
altos55822953al__tos
aluminas1048353aluminas
alumines10411683alumines
aluminous1145293aluminous
alumins9512983alumin_s
alumnus935223alumnus
alvine94614583alvin_e
ambients1246053ambients
ambits103713413ambi_ts
amboinas1246033amboinas
ambones11312683ambones
ambos95321253amb__os
amigos94511213a_migos
amines84727983a_mines
amino75425503a_mino_
amins75534323a_min_s
ammines11312673ammines
ammino1069883ammino_
amnions93710913amnions
amnios84912523amni_os
anginas8310953anginas
anginose945903anginose
anginous947643anginous
anions64123033a_nions
anoints7311063anoints
antings85015583antings
arabinose1144063arabinose
armings103811503armings
aroints7313133aroints
arsines73518813arsines
arsino64113513arsino_
askings12519173askings
audings9289393audings
audios72312283audi_os
auxins13129813auxin_s
avions94114393a_vions
avisos95410483a_visos
awnings11406713awnings
axions134713483a_xions
ayins85321613a_yin_s
azines155517073a_zines
bambino1336483bambino_
bigos85020013__bigos
binds86627473__binds
bines76946793__bines
bingos95514793__bingos
binocs1039923__binocs
bins66548253__bin_s
bints76130183__bints
bios66335323__bi_os
biros75325133__biros
blains84516373blain_s
blinds95111613bl_inds
blinis85313683bl_inis
blinks124613573bl_inks
bluings10327963bluings
cabins104418923cabin_s
calcines12314753calcines
calicos113913493cal_icos
calkings15289223calkings
calkins133814873calkin_s
callings113613833callings
carbines123617533carbines
carbinol1245773carbinol
carbinols1346113carbinols
casinos93512833casinos
cassinos10309353cassinos
chinos115018693_chinos
clines84926043cl_ines
clings95716213cl_ings
clinks125815063cl_inks
coalbins1237083coalbin_s
dinos65428063__dinos
dominos103210193dominos
elains64919853elain_s
elfins94810943elfin_s
elints65816423el_ints
eloins65419383eloin_s
finos86226953__finos
flings106715283fl_ings
flints95617453fl_ints
flyings14496063flyings
gabions102410053gabions
glints75714213gl_ints
globins10278953globin_s
kinos96626143__kinos
labials9299873labials
lacings105013653lacings
ladings93814133ladings
ladino73615123ladino_
lakings124713513lakings
laminas93615873laminas
laminose1036913laminose
laminous1037953laminous
lapins84520683lapin_s
latigos8277243latigos
latinas74416463latinas
latino64120473latino_
lawines103313563lawines
lawings113611473lawings
layins93817653layin_s
lenos56024863_l_enos
libidos1044653libidos
lidos65219883_l_idos
lilos55821873_l_ilos
limos75320813_l_imos
lines57054573_l_ines
lings67135773_l_ings
links96430193_l_inks
linns56123333_l_inns
lino46343373_l_ino_
lins47059053_l_in_s
lints57137193_l_ints
lions55923213_l_ions
llanos6108333_llanos
loins56728423_loin_s
lyings10488503_lyings
malines93625603mal_ines
malkins133311803malkin_s
mallings113413093mallings
merinos9311983merinos
oleines7313393oleines
oleins6313523olein_s
olingos846013ol_ingos
olios54520853ol_i_os
palings103915823pal_ings
palominos1344063palominos
pepinos1137693pepinos
plains85019593plain_s
plaints94012053plaints
plinks124913263pl_inks
rabbins112811343rabbin_s
rebinds104511873rebinds
rhinos94411123_rhinos
robins83617453robin_s
rubigos1033653rubigos
sabines94318483sabines
sabins85521983sabin_s
salinas73116093sal_inas
salines74029413sal_ines
saltines82917793saltines
saltings92811253saltings
slings74618013sl_ings
slinks104315153sl_inks
talions7314113tal_ions
talkings13358403talkings
tubings10336483tubings
unbinds10267353unbinds
upbinds12234813upbinds
valines104520213val_ines
vinos84723073__vinos
walkings16327313walkings
winos84625043__winos

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 Limit1340272526.79619721.5
3Display Results2522520.0932709.7
 (SQL Overall)1786912527.27924548.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.