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

152 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
pandoras1131005(None) 
bandoras1138741bandoras
pandora1039541pandora_
pandores11312451pandores
panduras1136951panduras
angoras8811362_angoras
bandora1038812bandora_
bandores11311602bandores
candors104216762candor_s
mandolas1139132mandolas
pakoras1337472pa_koras
pandas95521962pand__as
panders103423732pander_s
pandoors11258982pandoors
pandore10411852pandor_e
pandours11317992pandours
pandura1037142pandura_
adores74420723_a_dores
adorns74212613_a_dorns
agoras7613343_a_goras
andros7313303_and_ros
angora71111573_angora_
annonas738793_annonas
anoas57226493_an_o_as
anorak1038923_an_orak
anoraks1137603_an_oraks
apnoeas946353apn_oeas
ardors74416873_ardor_s
auroras7311703_auroras
bandanas11178573bandanas
bandas95120543band__as
banders104324563bander_s
bandogs1138363bando_gs
bandore10611633bandor_e
calderas1147883calderas
candelas1139533candelas
candidas12338643candidas
candor94516423candor__
candours11408643candours
canolas9313993can_olas
cantors94620753cantor_s
canzonas1935383canzonas
carboras12311583carboras
condores113315643condores
condors104018573condor_s
danders93921183dander_s
expandors19142833expandor_s
fandoms13229473fando_ms
fanworts1446103fanworts
fedoras1137923_fedoras
ganders93521703gander_s
gondolas1046193gondolas
handcars1437623handcars
handers114224333hander_s
handoffs1844733handoffs
handouts1238233handouts
handworks2046703handworks
landers84026213lander_s
landforms1544113landforms
landgrab1243033landgrab
landgrabs1342863landgrabs
landlords1144453landlords
madras94316433ma_d_ras
mandalas1139443mandalas
mandiocas1443943mandiocas
mandola1039023mandola_
maniocas12298473maniocas
manors84420883man_or_s
mantras93815863man_tras
nandinas936573nandinas
padders113312873padder_s
paddocks1894323paddocks
padouks1434873pa_douks
padres95016983pa_d_res
pagodas11367553pa_godas
pakora1247283pa_kora_
palabras1267353palabras
pallors9314363pallor_s
palmyras1544033palmyras
palookas1443843palookas
panaceas1236763panaceas
panadas103312213pan_adas
panamas113112763pan_amas
pancreas1235393pancreas
panda85022613pand__a_
pandanus1136433pandanus
pandects1335843pandects
pander93725523pander__
pandered121812573pandered
panderer112210913panderer
panderers12229153panderers
pandies104224503pand_ies
pandits103914213pand_its
pandoor10358583pando_or
pandour10408213pando_ur
pandowdy1842143pandowdy
pandurate1245883pandurate
pangas99921103pan__gas
pangram1239023pan_gram
pangrams1337153pan_grams
paniers94717333panier_s
panners93621273panner_s
panochas1545653panochas
panorama1244943pan_orama
panoramas1344273pan_oramas
pantos85222743panto__s
pantoums1236713pantoums
panzers184012013panzer_s
paradores12259653paradores
paradors113411903parador_s
paras76143043pa___ras
pardons103817623pardo_ns
pareiras1038183pareiras
parlors9312913parlor_s
paruras9310533pa_ruras
pastoral10310483pastoral
pastorals1147953pastorals
pastors94119003pastor_s
paviors1237603pavior_s
pavlovas1642423pavlovas
pawnors12297203pawnor_s
payolas12148973pa_yolas
payors114312643pa_yor_s
pinders103720473pinder_s
pinworks17106353pinworks
pinworms15115783pinworms
planforms1643723planforms
ponders103618843ponder_s
rancors9811373rancor_s
randoms102112433rando_ms
rasboras1045893rasboras
rhodoras1244453rhodoras
sandarac1145833sandarac
sandaracs1244703sandaracs
sandbars11108783sandbars
sanders84025943sander_s
sandworms1545653sandworms
sandworts1346453sandworts
santeras8311063santeras
senhoras11278283senhoras
senoras72714953sen_oras
spanworms1643743spanworms
tandooris10224633tandooris
tandoors9258053tandoors
tantaras8269543tantaras
tantras73112093tan_tras
tundras857113tund_ras
vandas103915993vand__as
vendors113510223vendor_s
wanders114221333wander_s
yantras10259003yan_tras
zanders173015793zander_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 Filter1786911461620.423422437.4
2DLD Change Limit1461621526.53022383.2
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.99925530.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.