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

232 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
nandina83891(None) 
nandin7313031nandin_
nandinas936571nandinas
nandins8312001nandins
angina7413132_angina
bandana10179462bandana
banding114921412banding
candida114110252candida
cantina93417252cantina
handing123518892handing
landing92819322landing
nankin1039672nankin_
nankins1159052nankins
nardine82712572nardine
sanding93520602sanding
adding93914963_adding
aedine73218393_aedine
aiding84423613_aiding
amandine1148553amandine
anginal8310163_anginal
anginas8310953_anginas
anhinga11104813_anhinga
anima74620073_an_ima
anna45529013_an__na
annona648873_annona
anoint6423633_anoint
anting75827023_anting
auding83616933_auding
balding114015063balding
banana83213413ban_ana
banda85223103band__a
bandanas11178573bandanas
bandanna11174073bandanna
bandied114414303bandied
bandies104124863bandies
bandit93821133bandi_t
bandito103710043bandito
bandits103814793bandits
bandora1038813bandora
bandying15218073bandying
banging114019863banging
banian8315383ban_ian
baning95127833ban_ing
banking144621353banking
banning103818233banning
barding113822893barding
bending114420893bending
binding113819383binding
bonding113318433bonding
branding122513683branding
candela1089743candela
candent10417363candent
candid104517853candi_d
candidal12367733candidal
candidas12338643candidas
candids113812693candids
candied113816023candied
candies104125613candies
candling122313873candling
candying15188993candying
canine83826703can_ine
caning94128623can_ing
canna75919333can__na
canning103620133canning
cantinas102713773cantinas
canting104725903canting
canzona1836073canzona
cardia9916373cardi_a
cardinal1139553cardinal
carding113922433carding
carina84325323ca_rina
cassina94113163cassina
dancing113611563dancing
dandier93714573dandier
dandies94121443dandies
dandify15245673dandify
dandily12279633dandily
dandling112511733dandling
danging103716093danging
eanling81416673eanling
encina8310443_encina
ending83220253_ending
fading114821113fa_ding
fanning113615073fanning
fanzine1937123fanzine
farding123716743farding
farina94618233fa_rina
fending123717603fending
finding124116543finding
fonding123815423fonding
fontina1038633fontina
funding124113663funding
gadding113411453gadding
ganging103216193ganging
hading113922943ha_ding
handicap1644933handicap
handier113817443handier
handily143610873handily
handling132312713handling
hanging123518703hanging
haniwa1236743han_iwa
hanking154619103hanking
hanting114124483hanting
jading154214023ja_ding
jarina134014063ja_rina
kachina1637663kachina
katcina1345153katcina
lading84227123la_ding
ladino73615123la_dino
lamina84920443la_mina
lancing103314123lancing
landings103110073landings
landline9311443landline
landman1038923landman
lantana739603lantana
larding92917873larding
latina65621143la_tina
lauding93211903lauding
lending94118533lending
madding123711993madding
manana84816073man_ana
mandala10310203mandala
mandioca1354113mandioca
mandola1039023mandola
mania75634143man_i_a
manila84518303man_ila
mankind1437773mankind
manna75522533man__na
manning103616383manning
marina84623413ma_rina
medina94114093_medina
mending114018683mending
minding113317893minding
nabbing12299963nabbing
nada58022903na_d__a
nadir61012973na_di_r
nadiral836343na_diral
nadirs7109003na_dirs
naffing14359033naffing
nagana748943na_gana
nagging102613043nagging
nailing83419963nailing
naira5314743na__ira
naming93917893na_ming
nana46632893na___na
nancies93516843nancies
nanism8311203nan_ism
nannie63713223nanni_e
nannies73015203nannies
nanny84813813nan__ny
napkin1236903napkin_
napkins1336673napkins
napping123514183napping
narine63422553na_rine
narking124015383narking
needing93214423needing
niding83217973n_iding
nodding103811513nodding
nomina83113683n_omina
nonfinal1147693nonfinal
numina83510843n_umina
padding123412513padding
panda85022613pand__a
pandani1039903pandani
pandied113913443pandied
pandies104224503pandies
pandit93820753pandi_t
pandits103914213pandits
pandora1039543pandora
pandura1037143pandura
pandying15217663pandying
panging113319113panging
panini8314273pan_ini
panino8315683pan_ino
panning104019393panning
panting104025423panting
pardine103616723pardine
pastina93914593pastina
patina86022193pa_tina
pending114119773pending
ponding114317083ponding
radding103715003radding
radian74117273ra_dian
raiding93617593raiding
randan7315253randan_
randans8313213randans
randier83618473randier
randies84225663randies
ranging94120263ranging
ranking124320883ranking
ranting84025413ranting
rending93924263rending
rendzina1843423rendzina
salina64221123sa_lina
sandier84017843sandier
sandling102214413sandling
sandman10310173sandman
sanidine939853sanidine
saning75127643san_ing
sarcina9310733sarcina
sardana838643sardana
sardine83317393sardine
scandia1038063scandi_a
sending94221373sending
standing103413633standing
tanging93419523tanging
tanking123918793tanking
tankini11338923tankini
tannin62613923tannin_
tanning83618253tanning
tannins72813223tannins
tending94419163tending
undine7817263_undine
unending10239943unending
unhanding1437203unhanding
vaccina1435303vaccina
vagina102710933va_gina
vanda94515923vand__a
vanning113912463vanning
vending124015263vending
wadding133711943wadding
wading114619533wa_ding
waning103623803wan_ing
wanking154216783wanking
wanning113816213wanning
wanting114220173wanting
warding123918143warding
wending123816843wending
winding123517913winding
yanking154512463yanking
yarding123413143yarding
zanana153810363zan_ana

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.203880251.2
2DLD Change Limit1340272327.33018284.7
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.62623431.8
 
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.