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

320 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
nuance85904(None) 
nance74721841n_ance
nuanced1036201nuanced
nuances938521nuances
chance134617092chance
dance85223132_dance
dunce86319262du_nce
durance1059112durance
enhance1239692enhance
fiance11310742fiance
glance94312312glance
hance105424152_hance
jaunce15367432jaunce
lance75126722_lance
launce8469182launce
nances83618642n_ances
nancy105214922n_ancy
nonce75719822n_once
nuisance1045712nuisance
nuncle839362nu_ncle
ounce77019932ou_nce
prance104318572prance
quince173910132quince
rance75028512_rance
seance83716692seance
stance84316912stance
trance84718762trance
usance858012usance
ace59656833__a_ce
acne66625873__acne
acutance1246303acutance
advance1346043advance
alane56135613alan_e
ananke1038283ananke
andante8311273andante
ane37866953__an_e
anlace82513923anla_ce
ante46538903__ante
apace94718383apa_ce
askance1345923askance
balance11510263balance
banco94019393_banco
bane65250433_ban_e
beanie83618593beanie
blanch133410853blanch
bounce104014833bounce
brace95629273bra_ce
branch134014773branch
bunch125118603bu_nch
bunco94616083bu_nco
buoyance1543713buoyance
burnie83715413burnie
butane8313653butan_e
cancel105316683_cancel
cancer104220923_cancer
cane66653123_can_e
canoe75627253_canoe
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
chancre14348783chancre
chancy164010863chancy
change124116753change
cranch133613533cranch
crane75331603cran_e
dace76934923_da_ce
danced105315253_danced
dancer94817613_dancer
dances95120653_dances
duce76933503du__ce
duende836923duende
dunces95215753du_nces
dunch115316263du_nch
dune56137583du_n_e
durances1158683durances
endurance1245243endurance
enface112510353enfa_ce
enhanced1436623enhanced
enhancer1346683enhancer
enhances1339293enhances
enlace82213233enla_ce
enounce937573enounce
entrance10311333entrance
evince1137763evince
face96140123_fa_ce
fancy134615483_fancy
fane75343573_fan_e
farce104925323_farce
faunae95210373faunae
fence105319913_fence
fiancee1238953fiancee
fiances12310673fiances
finance1238573finance
flange103411973flange
franc104615413franc_
francs114112193francs
furane94015493furan_e
furnace1235943furnace
gane55145303_gan_e
glace87420153gla_ce
glanced11439233glanced
glancer103710073glancer
glances104113143glances
grace85124543gra_ce
grange83716203grange
guaco85012163gua_co
guan55325583guan__
guanaco1064583guanaco
guanase836213guanase
guanay1037913guanay
guanin7610803guanin
guanine8810543guanine
guano69213983guan_o
guanos73811993guanos
guans64419443guan_s
guidance1244983guidance
hances115621283_hances
hanse85722793_hanse
haunch14377343haunch
hence104920043_hence
humane112812173human_e
hunch136416213hu_nch
inane52820343inan_e
infancy1546173infancy
infante101910883infante
inlace82513043inla_ce
insane6314893insan_e
instance1049883instance
insurance1147453insurance
issuance1045223issuance
jane115031483_jan_e
jaunced17335473jaunced
jaunces16307423jaunces
jounce153310733jounce
joyance1944773joyance
juice14311323ju_ice
junco144612203ju_nco
kane85133973_kan_e
kune85424573ku_n_e
lace66848473_la_ce
lanced93717723_lanced
lancer84319973_lancer
lances84824103_lances
lancet84223573_lancet
lane45153333_lan_e
launces9329003launces
launch11368063launch
liane54720663lian_e
luce65132573lu__ce
lucence11148003lucence
lunacy1136843lunacy
lunate6316043lunate
lunch104917243lu_nch
lune47140493lu_n_e
lunge65323803lu_nge
mace87345793_ma_ce
manche133515103_manche
mane65052033_man_e
mange84930193_mange
manse75528233_manse
meanie83718393meanie
menace103216943menace
mince95325233_mince
munch124917103mu_nch
naan47621933naan__
naans55815253naan_s
nabe66029493n_a_be
nacre75715363n_acre
nae35952743n_a__e
naive85116213n_aive
name65637413n_a_me
nan37854883n_an__
nana46632903n_an_a
nanas55928633n_anas
nancies93516843n_ancies
nannie63713223nannie
nanny84813813n_anny
nans46139403n_an_s
nape65230803n_a_pe
nappe96114993n_appe
narc67127953n_arc_
narco76718243n_arco
narcs76122023n_arcs
natch105018223n_atch
nautch1144813nautch
nave75732313n_a_ve
nene45932063n_en_e
nice65534713n__ice
niece74814503n_iece
nine45842173n_in_e
nonage7313683nonage
nonces84418833n_onces
nondance1148243nondance
none45743173n_on_e
notice8313443notice
novice1138433novice
nubble103813713nubble
nubile83212713nubile
nubuck1434543nubuck
nuchae11218513nuchae
nude56626273nu__de
nudge74616433nu_dge
nudie65118673nu_die
nudnick1452863nudnick
nudnik1153313nudnik
nuisances1145333nuisances
nuke85920753nu__ke
nun35537743nu_n__
nuncio837973nu_ncio
nuncles939843nu_ncles
nuns45228233nu_n_s
nurse54420123nu_rse
nutant6316383nutan_t
nutate63017373nutate
nuzzle14298083nuzzle
once65423083__once
orange74016323orange
ounces83617773ou_nces
outdance11238733outdance
outrance102212783outrance
pace86345773_pa_ce
pane64950293_pan_e
panne76623653_panne
paunch13369853paunch
peace95026083pea_ce
penance11313443penance
pence94924453_pence
piquance2144213piquance
place94824613pla_ce
plaice10311553plaice
planch133711443planch
planche14299753planche
plane74929143plan_e
ponce95222513_ponce
pounce105214093pounce
pranced123714043pranced
prancer113613383prancer
prances113618773prances
prince104114763prince
puce85127883pu__ce
pumice1238223pumice
punch125118423pu_nch
quack203812503qua_ck
quaere154110673quaere
quaich2047693quaich
quake184114643qua_ke
quale143617853qua_le
quango1636493quango
quant143624813quan_t
quanta153911333quanta
quanted1738963quanted
quants153614143quants
quare143920543qua_re
quarte154115323quarte
quate144521413qua_te
quatre153512353quatre
quench2036633quench
quinces183210433quinces
quinte153414523quinte
race66746263_ra_ce
rances84625443_rances
ranch105019793_ranch
ranee55438103_ranee
range64728413_range
raunch11358433raunch
romance11311083romance
ruana5312423ruan_a
ruanas6311263ruanas
rubace10310173rubace
rune45236303ru_n_e
saice75424053_saice
sane45954343_san_e
sauce75121653_sauce
scarce104013633scarce
sconce104711723sconce
seances93015343seances
since75024173_since
sonance9310313sonance
space95325673spa_ce
spancel1147363spancel
spence103813793spence
stances93715963stances
stanch113812373stanch
stane55933003stan_e
suable83920553suable
suave83519873sua_ve
tace65342513_ta_ce
tenace82715693tenace
tendance1147523tendance
thane86122533than_e
thence112010843thence
trace75829613tra_ce
tranced104414173tranced
trances93919643trances
tranche123312223tranche
truancy1244993truancy
tune45635863tu_n_e
ulnae55214573_ulnae
unable83819223unable
unbe65319273_u_nbe
unci65019463_u_nci
uncle7317053_u_ncle
unco66021403_u_nco
unde55825483_u_nde
undulance1244063undulance
unfancy1545203unfancy
unfence1239193unfence
unlace82215173unlace
unnuanced1243413unnuanced
usances967373usances
usaunce9103383usaunce
valance1269253valance
vane75534693_van_e
wane76344723_wan_e
whence14187923whence
wince105220883_wince
yince105214253_yince
yuan76120013yuan__
yuans84613323yuan_s

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.393454684.5
2DLD Change Limit1127163205.54620323.8
3Display Results3203200.0933440.9
 (SQL Overall)1786913206.03229623.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.