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

240 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
pandore1041185(None) 
bandore10611631bandore
pandora1039541pandora
pandores11312451pandores
adore65723672_a_dore
bandora1038812bandora
bandores11311602bandores
candor94516422candor_
candors104216762candors
padre86018162pa_d_re
pander93725522pander_
pandered121812572pandered
panderer112210912panderer
panders103423732panders
pandoor10358582pandoor
pandoors11258982pandoors
pandoras11310052pandoras
pandour10408212pandour
pandours11317992pandours
pandura1037142pandura
adobe84814713_a_dobe
adored84714243_a_dored
adorer74713453_a_dorer
adores74420723_a_dores
adorn64917093_a_dorn
adoze155713833_a_doze
afore85818603_a_fore
aldose7311093_aldose
ancone83916953_ancone
andro6314163_and_ro
andros7313303_andros
angora71111573_angora
anode65021043_an_ode
anole55330383_an_ole
antre55224523_an_tre
anymore1256243_anymore
anyone94612733_anyone
ardor64617863_ardor_
ardors74416873_ardors
ashore9414613_ashore
bandage11311023bandage
bander93928223bander_
banders104324563banders
bandog1038723bando_g
bandogs1138363bandogs
bandoras1138743bandoras
cadre85419023ca_d_re
candle94321483cand_le
candler103516593candler
candour104210243candour
candours11408643candours
canoe75627253can_o_e
canoer85121073can_oer
cantor85621523cantor_
cantors94620753cantors
canzone1858813canzone
condole102914953condole
condone102616293condone
condor94616973condor_
condores113315643condores
condors104018573condors
dander811222993dander_
dandered112110963dandered
danders93921183danders
dandier93714573dandier
dandle84218093dand_le
dandler94414273dandler
dore56353303___dore
encore8314773_encore
endorse879203_endorse
endure74014143_endure
expandor18142763expandor_
expandors19142833expandors
fandom122110893fando_m
fandoms13229473fandoms
fanfare1336673fanfare
fanwort13310733fanwort
galore73514853ga_lore
gander84322763gander_
gandered112211173gandered
ganders93521703ganders
hander104526433hander_
handers114224333handers
handier113817443handier
handle104219293hand_le
handler113516163handler
handoff1756483handoff
handout11314103handout
handover15126823handover
handsome1447603handsome
handwork1946903handwork
hardcore1446043hardcore
ignore7269063ign_ore
indole74516053_indole
indorse8108193_indorse
lander74028483lander_
landers84026213landers
landform1445223landform
landler84113203landler
landlord1045163landlord
lanose6313593lan_ose
madre85720173ma_d_re
mandate10315573mandate
mandola1039023mandola
mandrel1038683mand_rel
manhole12311343manhole
mannose939243mannose
manor78023933man_or_
manors84420883man_ors
manrope1138033manrope
manure8313653man_ure
moidore1056153moidore
noncore9411953noncore
padder103415493padder_
padders113312873padders
paddle104615143pa_ddle
paddler113711553paddler
paddock17104733paddock
padle84522343pa_d_le
padouk1336683pa_douk
padres95016983pa_d_res
padri85815173pa_d_ri
padrone102512073padrone
pakora1247283pa_kora
pallor8313673pallor_
pallors9314363pallors
panache1458423panache
pancake1536673pancake
panda85022613pand__a
pandani1039903pandani
pandas95521963pand_as
pandect12310953pandect
panderers12229153panderers
pandied113913443pandied
pandies104224503pandies
pandit93820753pand_it
pandits103914213pandits
pandowdy1842143pandowdy
panduras1136953panduras
pandurate1245883pandurate
pandy115021173pand__y
pane64950293pan___e
panfry14456413pan_fry
pangene102711963pangene
panicle11129983panicle
panier84425503panier_
paniers94717333paniers
panne76623653pan__ne
panner84224763panner_
panners93621273panners
pannier93613353pannier
panoche1456383panoche
panpipe1034833panpipe
panther12611443panther
pantie84326473pan_tie
pantile93918483pantile
panto76129413panto__
pantofle1364553pantofle
pantos85222743panto_s
pantoum1138703pantoum
pantry115014103pan_try
panzer174213233panzer_
panzers184012013panzers
papoose1147513papoose
pappose1047413pappose
parador103311413parador_
paradores12259653paradores
paradors113411903paradors
pardee93922023pard_ee
pardie96021443pard_ie
pardine103616723pardine
pardner10239473pardner
pardon94618733pardo_n
pardoned12189333pardoned
pardoner11189443pardoner
pardons103817623pardons
pare66760843pa___re
parlor8312673parlor_
parlors9312913parlors
parole84425253pa_role
parure8312523pa_rure
pastor84817483pastor_
pastored1139963pastored
pastors94119003pastors
pasture9311463pasture
pavior1138533pavior_
paviors1237603paviors
pawnor11357243pawnor_
pawnors12297203pawnors
payor105413843pa_yor_
payors114312643pa_yors
pentode1039893pentode
pentose9311593pentose
perdure10379623perdure
pinafore1344513pinafore
pinbone1138183pinbone
pinder94523453pinder_
pinders103720473pinders
pinhole122010433pinhole
pinole83218783pin_ole
pinwork16107243pinwork
pinworm1467183pinworm
planform1544753planform
ponder94521693ponder_
pondered126411293pondered
ponderer112410193ponderer
ponders103618843ponders
pore66451263p___ore
radome9511873ra_dome
rancor8810373rancor_
rancored1137223rancored
rancors9811373rancors
randier83618473randier
random92513553rando_m
randoms102112433randoms
rondure837313rondure
sander74828533sander_
sanders84025943sanders
sandier84017843sandier
sandworm1446343sandworm
sandwort12410083sandwort
snore55424953_sn_ore
spandrel1144063spand_rel
spanworm1544203spanworm
tandoor8278563tandoor
tandoori9244773tandoori
tandoors9258053tandoors
undoer73113043_undoer
undone7914253_undone
vadose1037963va_dose
vandyke1842513vandyke
vendor10359803vendor_
vendors113510223vendors
wander104423713wander_
wandered132110793wandered
wanderer122210123wanderer
wanders114221333wanders
wandle105316663wand_le
zander163417113zander_
zanders173015793zanders

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272406.42320866.7
3Display Results2402400.0932580.6
 (SQL Overall)1786912406.93625762.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.