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

414 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
randans831321(None) 
randan7315251randan_
bandana10179462bandana
bandanas11178572bandanas
bandas95120542banda_s
banians9312032banians
banyans1237912banyans
cancans11311872cancans
grandads1136552grandads
grandams1237122grandams
kanbans1337722kanbans
landaus8310342landaus
mannans93611522mannans
nandins8312002nandins
pandani1039902pandani
pandanus1136432pandanus
pandas95521962panda_s
radars71314672ra_dars
radians83013822radians
radons74118532ra_dons
raglans82410132raglans
randies84225662randies
randoms102112432randoms
rands65930452rand__s
ratans63819372ra_tans
rattans73411952rattans
redans75421022r_edans
sandals82715202sandals
vandals113211662vandals
vandas103915992vanda_s
wangans1149502wangans
abandons1145353abandons
alans55636173_a_lans
anas46649863_an_a_s
andante8311273_andante
andantes9310853_andantes
andros7313303_andros
ands57833613_and__s
anears63717183_anears
angas65827983_anga_s
anions64123033_anions
anlas55626933_anla_s
annals66415923_annals
annas55824883_anna_s
anoas57226493_anoa_s
antas55432033_anta_s
anurans73810553_anurans
anyons94513503_anyons
atmans84413963_atmans
audads8167103_audads
avians93711563_avians
azans146516883_a_zans
badass949293ba_dass
banana83213413ban_ana
bananas93312223ban_anas
banda85223103banda__
bandage11311023bandage
bandages12310633bandages
bandaid11310483bandaid
bandanna11174073bandanna
bandannas12163283bandannas
bandeaus1146503bandeaus
banders104324563banders
bandies104124863bandies
banding114921413banding
bandits103814793bandits
bandogs1138363bandogs
bands85233423band__s
bandsaws1444623bandsaws
banian8315383banian_
banns75321233ban__ns
bantams1149063bantams
banyan1139483banyan_
banzais1837163banzais
bendays13327513bendays
brainpans1343303brainpans
branders114313093branders
brandies11714563brandies
branding122513683branding
brandings13277483brandings
brands95118943brand__s
caftans12179443caftans
caimans113811783caimans
callans94518473callans
canals84421663can_als
cancan10314103cancan_
candent10417363candent
candids113812693candids
candies104125613candies
candles104422343candles
candors104216763candors
cannas84518403canna_s
cannons94412883cannons
canons85522063can_ons
cantals93919573cantals
cantons95221203cantons
canvas113813333canva_s
canvass12376873canvass
canyons124511593canyons
captans111612053captans
cardons104519933cardons
caymans14349513caymans
crawdads1542653crawdads
dadas75819863da_da_s
damans94715983da_mans
danders93921183danders
dandies94121443dandies
dandles94218533dandles
dans56748153___dans
dedans85915073_dedans
fandango1342993fandango
fandangos1442293fandangos
fandoms13229473fandoms
fangas105017193fanga_s
fanions103713073fanions
fanons96115213fan_ons
fondant11311143fondant
fondants1246203fondants
ganders93521703ganders
ganjahs18104003ganjahs
ganjas14149113ganja_s
gardant9314463gardant
gardens93312093gardens
gaydars1235803gaydars
gradins93416233gra_dins
grandad1038453granda_d
grandam1139393granda_m
grandame1247113grandame
grandames1346713grandames
grandaunt1144703grandaunt
grandaunts1252943grandaunts
granddads1343463granddads
granddams1443483granddams
grandees103211283grandees
grandmas1236923grandmas
grandpas1236003grandpas
grands84218243grand__s
grandsons1145123grandsons
hagdons1258523hagdons
handax1749583handa_x
handaxes1938403handaxes
handbags15116363handbags
handcars1437623handcars
handers114224333handers
handguns1344363handguns
handing123518893handing
handles114020653handles
hands95327383hand__s
handsaws1545873handsaws
hangars114313493hangars
hansas94616043hansa_s
hanumans1344953hanumans
hardass1139753hardass
hardens113815023hardens
hardpans1436453hardpans
hazans183411653ha_zans
hazzans18215783hazzans
honans94814503hon_ans
hondas10313353honda_s
japans1539823ja_pans
jawans1657843ja_wans
jordans1566833jordans
kaftans14185353kaftans
kalians11310183kalians
kanas95326913kan_a_s
kanban1238623kanban_
kantars11310033kantars
ladens74516233la_dens
lagans75717783la_gans
lallans74113533lallans
lanais6316793lan_ais
landau7310613landa_u
landers84026213landers
landing92819323landing
landings103110073landings
landman1038923landman_
landmass1144423landmass
lands65426903land__s
lantana739603lantana
lantanas838263lantanas
lardons83914493lardons
lauans65113533la_uans
lindane839033lindane
lindanes939173lindanes
lindens839413lindens
longans84510813longans
lungans8399053lungans
lurdans837073lurdans
madams11310943ma_dams
maddens11359753maddens
magians10310753magians
maidens10349663maidens
manana84816073man_ana
mananas93414733man_anas
manas76240433man_a_s
manats84623463man_ats
mandala10310213mandala
mandalas1139443mandalas
mandamus1345523mandamus
mandarins12410393mandarins
mandate10315573mandate
mandates11314093mandates
mangas94122923manga_s
maniacs114313063maniacs
manias84029033mania_s
mannan85413623mannan_
mannas85019803manna_s
mantas85725363manta_s
manuals9311213manuals
maydays1634493maydays
minyans1237263minyans
mundane1038073mundane
naans55815253__naans
nadas66320813na_da_s
nanas55928633nan_a_s
nandin7313033nandin_
nandina838913nandina
nandinas936573nandinas
nankins1159053nankins
nans46139403__n_ans
nonfans1037533nonfans
padnags1135083padnags
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
panadas103312213panadas
panda85022613panda__
panders103423733panders
pandies104224503pandies
pandits103914213pandits
pangas99921103panga_s
pangens103112063pangens
pardahs13289673pardahs
pardons103817623pardons
parians93519733parians
partans94418283partans
pavans115715593pa_vans
paydays1634433paydays
pendant10314853pendant
pendants1139093pendants
qanats154112813qan_ats
qindars17267423qindars
quandang1943293quandang
quandangs2042253quandangs
rabats83116223ra_bats
rabbins112811343rabbins
racons84319343ra_cons
racoons93912433racoons
radar61316723ra_da_r
radding103715003radding
raddles93615703raddles
radials83614633radials
radian74117273radian_
radiant82817133radiant
radiants9259443radiants
radios74018673ra_dios
radius73914873ra_dius
radon64620503ra_don_
rads56046603ra_d__s
ragas65326063ra_ga_s
ragbags1135113ragbags
raglan73711503raglan_
ragman94013713ragman_
ragtags935373ragtags
raias54631123ra_ia_s
raiders84615143raiders
raiding93617593raiding
raids65827513raid__s
rainband1144663rainband
rainbands1244193rainbands
rains55140233ra__ins
raisins72715343raisins
raitas64417673raita_s
rajahs16497663ra_jahs
rajas127317723ra_ja_s
ramadas1039303ramadas
ramonas9311093ramonas
rampant11312173rampant
ramsons939563ramsons
rances84625443ran_ces
ranches123620113ranches
ranchos123911393ranchos
rancors9811373rancors
rand55839573rand___
randier83618473randier
randiest93418773randiest
randiness102511443randiness
random92513553rand_om
randy95022083rand__y
ranees64623963ran_ees
rangers83621043rangers
ranges73826923ran_ges
ranging94120263ranging
ranids75118703ran_ids
ranis55235833ran__is
rankers113217463rankers
ranking124320883ranking
rankings13389173rankings
rankles113114543rankles
ranks95225733ran__ks
ransack1346463ransack
ransacks1445773ransacks
ransoms92410163ransoms
ranters73323643ranters
ranting84025413ranting
rants55935343ran__ts
ranulas7311773ranulas
rascals959663rascals
ratals64219583ra_tals
ratan53722663ra_tan_
ratany93411873ra_tany
ratbags1035763ratbags
rations74123433rations
ratlins73615583ratlins
ratoons73815473ratoons
rattan63613603rattan_
rattens74213403rattens
rattons73815323rattons
ravens93916883ra_vens
ravins94622563ra_vins
rawins95617623ra_wins
rayahs12579193ra_yahs
rayas85922053ra_ya_s
rayons94113343ra_yons
redan66125013r_edan_
reddens9259783reddens
redons75222183r_edons
reloans7313133reloans
remans84823003r_emans
renders83821673renders
rending93924263rending
rends65129953rend__s
renins64526453ren_ins
rennins74013413rennins
renowns10277833renowns
rentals74017473rentals
replans92814943replans
rinds64826143rind__s
roans54926443r__oans
romans84620243r_omans
rondels82510053rondels
rondos74616733rond_os
ronions73313343ronions
ronyons10258433ronyons
rowans95715343r_owans
ruanas6311263ruan_a_s
rundles83214713rundles
rundowns1284533rundowns
runways13134443runways
rynds9569973rynd__s
ryokans1443293ryokans
saddens9309603saddens
sampans112411003sampans
sandal73317283sanda_l
sandbags1296373sandbags
sandbank1544873sandbank
sandbanks1644213sandbanks
sandbars11108783sandbars
sanddabs1243903sanddabs
sanders84025943sanders
sandhis1139993sandhis
sanding93520603sanding
sandman10310173sandman_
sands65228583sand__s
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sansars73313913sansars
sarans64224433sa_rans
sardana838643sardana
sardanas937813sardanas
sardars83112903sardars
scandals1136993scandals
sedans74816093_sedans
sendals81912263sendals
soldans83210403soldans
soudans8309353soudans
suldans8299723suldans
sundaes8313093sundaes
suntans72111733suntans
swanpans1343423swanpans
taipans9269553taipans
tampans113310983tampans
tandems1037633tandems
tankas104613763tanka_s
tannins72813223tannins
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tendons8311473tendons
trangams1147203trangams
trapans92812463tra_pans
unbans81912623_unbans
unmans82211993_unmans
uranias72113813urania_s
vanda94515923vanda__
vandal103713833vanda_l
vanman1139793vanman_
verandahs1642293verandahs
verandas1246233veranda_s
wanders114221333wanders
wands96425483wand__s
wangan10311223wangan_
wanguns1135023wanguns
wanigans1244743wanigans
wanions104011373wanions
wantons103713013wantons
wardens113711903wardens
xanthans1845693xanthans
zanana153810363zan_ana
zananas16319563zan_anas
zanders173015793zanders
zanzas1487053zanza_s

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.1401276364.3
2DLD Change Limit1340274147.47017942.0
3Display Results4144140.1402957.1
 (SQL Overall)1786914147.75023056.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.