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

489 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
nicads93833(None) 
nicad8312611nicad_
cads76144522__cads
cicada1136412cicada
cicadas1235982cicadas
cycads14476212cycads
jihads1734482jihads
micas96823052mica_s
naiads739012naiads
niches114419142niches
nicks114920492nic_ks
nicols8810242nicols
nipas77116672nipa_s
nizams1735412nizams
nomads94711602nomads
picas94626522pica_s
scads85419952_scads
ticals83214712ticals
vicars11712262vicars
acids87121003_acids
ads49755733___ads
aids57846353ai__ds
alcade91111513alcade
alcades101011473alcades
alcids94812293alcids
alidads936293alidads
animals94111703animals
animas84418723anima_s
apicals1159923apicals
arcade91013643arcade
arcades101113193arcades
arnicas939543arnica_s
audads8167103audads
bads77048863__bads
beads85429503_beads
becaps123811403becaps
bias64738163bi_a_s
bicarb1238543bicarb
bicarbs1336013bicarbs
biceps12447713biceps
bices95029963bic_es
bids75838433bi__ds
bields94110003bields
bimahs13508303bimahs
bimas95521743bima_s
binds86627473bi_nds
bipeds11458053bipeds
bipods11408593bipods
birds85421333bi_rds
brads85528293_brads
breads95419203breads
broads94515143broads
cabs86739423__cabs
cacaos104616183cacaos
cacas95627983caca_s
cad67456363__cad_
cade76443913__cade
cades85440733__cades
cadi75732173__cadi
cadis84428493__cadis
caids85226423__caids
cams87047283__cams
cans65050843__cans
caps87147893__caps
cards85137933__cards
cars67364763__cars
cats66356343__cats
caws96036103__caws
cays95437673__cays
chads116122233_chads
chicas135916463chica_s
cicadae1244853cicadae
cicala10310053cicala
cicalas1139293cicalas
cicale10314503cicale
cigars9910713cigars
clads85722733_clads
cocas95926573coca_s
cods76848103__cods
cuds76730473__cuds
cycad13507273cycad_
cycas126513823cyca_s
dads67442773__dads
deads75726913_deads
decade104216163decade
decades113615513decades
decafs124010883decafs
decals93717713decals
decays124612913decays
diacids1137853diacids
dials64925343di_als
dicast9315573dicast
dicasts1078703dicasts
diced95824683diced_
dicers94720743dicers
dices86434243dic_es
dicks125824693dic_ks
dicots94915793dicots
dinars75417563dinars
dirams94413703dirams
discards1238913discards
ditas65923673dita_s
divans104612393divans
divas95418583diva_s
diwans105110373diwans
dreads84115023dreads
dryads11436623dryads
duads76515343_duads
ducats95011763ducats
dyads10549973_dyads
egads74610923_egads
enneads834733enneads
ericas8315463erica_s
escars83913133escars
facade1238803facade
facades1339033facades
fads86939873__fads
farads104713273farads
fiars86720833fi_ars
fiats85324483fi_ats
fices106031163fic_es
fiches145219533fiches
fichus14388113fichus
ficins113513983ficins
ficoes114613463ficoes
ficus105015493fic_us
fids87034733fi__ds
fields104211043fields
fiends104110293fiends
finals94316163finals
fincas113512073finca_s
finds95424823fi_nds
fiords10498623fiords
fiscals1238003fiscals
gads67843383__gads
gids65933733gi__ds
gigas75415583giga_s
gilds75417523gi_lds
girds74816993gi_rds
glads75620613_glads
goads77022853_goads
gonads84511733gonads
grads75625753_grads
heads95127113_heads
hexads17468193hexads
hicks145322173hic_ks
hijabs1833083hijabs
hinds96721473hi_nds
hodads1147963hodads
iced78721893_iced_
ices66129643_ic_es
ichs96214713_ic_hs
icons76516493_icons
ictus7249693_ictus
ids47535463_i__ds
ikats95311153_ikats
iliads7448673iliads
imams91511113_imams
imids86015143_imids
incage93513623incage
incages103013883incages
incant82418503incant
incants92012803incants
incase83615283incase
incases93615973incases
inches114419673inches
incogs937903incogs
incudes10319523incudes
incurs83012273incurs
incus73315053inc_us
indicans1147663indicans
inlands838783inlands
inlays9389873inlays
innards837153innards
inroads837043inroads
invade10157853invade
invades11118293invades
invars9310003invars
inwards1138343inwards
irade65618153_irade
irades74517393_irades
irids66417773_irids
izars145112933_izars
jacals1539873jacals
jehads1735833jehads
jicama1734873jicama
jicamas1845043jicamas
jihad1635913jihad_
kicks104420083kic_ks
kids96029633ki__ds
kinas95626913kina_s
kinds106221813ki_nds
kivas124614733kiva_s
kneads11357093kneads
lads56549133__lads
leads66028493_leads
liards75212613liards
liars54723163li_ars
liches114724293liches
lichis115212593lichis
lichts113712383lichts
licks115325393lic_ks
lidars7310783lidars
lids56336453li__ds
ligands9438983ligands
ligans76817733ligans
lilacs837483lilacs
limans84816303limans
limas75627633lima_s
linacs8310813linacs
lipids94310923lipids
liras56021983lira_s
litas54923773lita_s
lizards17427613lizards
loads65323373_loads
locals83714503locals
macaws1337023macaws
mads76845363__mads
meads85425323_meads
menads95514383menads
mica86428253mica__
miches134320733miches
micks135525373mic_ks
micros104115363micros
mics87435153mic__s
mids76541783mi__ds
mikado1344513mikado
mikados1444683mikados
miladi938883miladi
miladis1049813miladis
milady1236613milady
milds86422053mi_lds
minas75434113mina_s
minds85427123mi_nds
minicabs14135063minicabs
minicams14126863minicams
minicars12118503minicars
misadd1037163misadd
misadds1136303misadds
monads94515303monads
naans55815253n_aans
nabs66236193n__abs
nachas114914193nachas
naches114622413naches
nachos115014183nachos
nacres85614453nacres
nada58022903n__ada
nadas66320813n__adas
nags55436023n__ags
naiad6313403naiad_
naiades838213naiades
nairas6312773naira_s
nalas55528363nala_s
naleds7469133naleds
nanas55928633nana_s
nans46139393n__ans
naos47429733n__aos
napas75924353napa_s
naps66238583n__aps
nards65928463n_ards
nasals63312463nasals
navaids1134803navaids
navars92810573navars
nawabs1185063nawabs
nays75931593n__ays
neaps75618323n_eaps
nears55529423n_ears
neats55931903n_eats
necks115119333nec_ks
nectars938463nectars
needs65719633n_eeds
nemas75321573nema_s
nerds65719253n_erds
niacin8310223niacin
niacins938543niacins
nibs65028313ni__bs
nice65534713nic__e
nicely1139493nicely
nicer74618293nic_er
nicest82315663nicest
nicety1138433nicety
niche105016793nic_he
niched125514063niched
nick106627603nic__k
nicked135019683nicked
nickel123811343nickel
nickels13338653nickels
nicker123818703nicker
nickers134415093nickers
nickle123814483nickle
nickles133713823nickles
nicoise937923nicoise
nicol71113293nic_ol
nictate9310223nictate
nictates1039583nictates
nidal65217103nida_l
nidate7313783nidate
nidates8311883nidates
nide55535783ni__de
nided75920873nided_
nides65229133ni_des
nidi56524393ni__di
nidus65913573ni_dus
nieces84112713nieces
nieves94311293nieves
niggards1144113niggards
nighs95013613ni_ghs
nights104117723nights
nihils937573nihils
nilgais845193nilgais
nilgaus844003nilgaus
nills54926673ni_lls
nils46132453ni__ls
nimbus10377283nimbus
nimrods1044283nimrods
nims66226883ni__ms
nines55937343ni_nes
ninjas1386303ninjas
ninons64913773ninons
ninths936933ninths
nipa69421633nipa__
nips65830923ni__ps
niseis63512023niseis
nisus56014393ni_sus
niters64624203niters
nites55736343ni_tes
nitid61817833nitid_
nitons64614903nitons
nitres65519333nitres
nitrids8269633nitrids
nitros64214123nitros
nits45741643ni__ts
nival84915773niva_l
nixed135714223nixed_
nixes124519623ni_xes
nixies135313873nixies
nizam16310253niza_m
nocks115121013noc_ks
nods55838223n__ods
nomad86016183nomad_
nomas74726413noma_s
nonas55126653nona_s
nopals84914023nopals
novas85215363nova_s
noways12127733noways
noyade1036423noyade
noyades1136563noyades
nuchals12216933nuchals
nurds65518523n_urds
ocas66729633_oca_s
ocicats11137413ocicats
octads987333octads
oilcans936813oilcans
onloads8246673onloads
orcas75918623orca_s
oreads73915773oreads
pacas96029403paca_s
pads76742953__pads
pecans101515833pecans
pians75126963pi_ans
pias66542553pi_a_s
pibals103813083pibals
pica85831493pica__
picador1245923picador
picadors1345843picadors
pical95524373pica_l
picara10311903picara
picaras11311273picaras
picaro10311323picaro
picaros11310893picaros
picks135226143pic_ks
picots104616443picots
pics85633913pic__s
piculs103511753piculs
pikas114218093pika_s
pilafs113511023pilafs
pilaus84114133pilaus
pilaws11399433pilaws
pimas94725103pima_s
pinas75434453pina_s
pipals104213643pipals
pitas77427673pita_s
pleads94613953pleads
quads154515843_quads
rads56046603__rads
reads64835273_reads
recaps103615733recaps
reclads1049993reclads
rials55026673ri_als
rias45540593ri_a_s
ribalds10236673ribalds
ribands10208393ribands
riced85825543riced_
ricers84120993ricers
rices75536153ric_es
riches115022083riches
ricins83618703ricins
ricks115126133ric_ks
ricracs1136363ricracs
rictus8379193rictus
rids56539543ri__ds
rinds64826143ri_nds
ritards8439943ritards
rivals94213183rivals
riyals94111083riyals
roads66523613_roads
salads75316963salads
scabs94818643_scabs
scad75725763_scad_
scags85520973_scags
scalds94813693_scalds
scams94423973_scams
scans74625103_scans
scars75433533_scars
scats75930603_scats
scuds85116243_scuds
shads95124483_shads
sials54227243si_als
sices75637273sic_es
sickos125112033sickos
sicks115127623sic_ks
sics65234093sic__s
sikas94617023sika_s
silds65520523si_lds
simars84916933simars
simas75727553sima_s
sisals63013573sisals
sitars65417593sitars
sizars154812623sizars
snicks124312473snic_ks
socas74026183soca_s
spicas104715823spica_s
squads164410293squads
steads74116223steads
tads57143943__tads
tical76021493tica_l
ticks115823293tic_ks
tics65729633tic__s
tictacs1145793tictacs
tilaks1097353tilaks
tincals93610633tincals
tipcats1137103tipcats
tirade7311693tirade
tirades8311723tirades
titans63414913titans
toads65621063_toads
treads74817913treads
triads74513523triads
triclads1146223triclads
uncaps1039813uncaps
uncials92510523uncials
unipods1095703unipods
unitards945623unitards
unleads8228623unleads
unloads8278523unloads
vials85822383vi_als
viands1047813viands
vicar10513863vica_r
viced115118183viced_
vices105725533vic_es
vids85627533vi__ds
vigas94817883viga_s
vinals94716483vinals
vinas85126343vina_s
vincas113912453vinca_s
visards11328153visards
visas84317653visa_s
vitals94514303vitals
vivas114815023viva_s
vizards20377263vizards
vocabs13336313vocabs
vocals113811583vocals
wads87343143__wads
wiccans1434603wiccans
wiccas1336543wiccas
wiches144418753wiches
wicks144619363wic_ks
wields10469623wields
wigans104511703wigans
wilds94818203wi_lds
winds95425603wi_nds
witans93412933witans
wizards20326403wizards
woads94818443_woads
yids85224953yi__ds
yields10466843yields
yirds96612513yi_rds
yucas106013913yuca_s
zirams17438643zirams

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.1231452772.4
2DLD Change Limit1127164895.89319127.1
3Display Results4894890.1563134.6
 (SQL Overall)1786914896.17228951.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.