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

162 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
pandour1040821(None) 
candour104210241candour
pandoor10358581pandoor
pandours11317991pandours
ardour74110902_ardour
candor94516422cando_r
candours11408642candours
handout11314102handout
padouk1336682pa_douk
pander93725522pand_er
pandoors11258982pandoors
pandora1039542pandora
pandore10411852pandore
pandura1037142pand_ura
pantoum1138702pantoum
parlour937262parlour
paviour1244622paviour
rancour987132rancour
sandbur10105352sandbur
santour737372santour
tandoor8278562tandoor
adnoun757033_adnoun
amour75014853_a_mour
apodous1037403apodous
arbour84211333_arbour
ardor64617863_ardo_r
ardours8368883_ardours
armour84411853_armour
bander93928223band_er
bandog1038723bando_g
bandogs1138363bandogs
bandora1038813bandora
bandore10611633bandore
candler103516593candler
candors104216763candors
canoer85121073can_oer
cantor85621523canto_r
clangour11293803clangour
condor94616973condo_r
contour939973contour
dander811222993dand_er
dandier93714573dandier
dandler94414273dandler
danseur833663danseur
dour56330433___dour
enamour945433enamour
expandor18142763expando_r
faitour1034883faitour
fandom122110893fando_m
fandoms13229473fandoms
favour12438333fa_vour
gander84322763gand_er
grandeur10305673grandeur
handcar1337373handcar
hander104526433hand_er
handful14127253handful
handgun1244623handgun
handier113817443handier
handler113516163handler
handoff1756483handoff
handouts1238233handouts
handover15126823handover
hangout11411393hangout
harbour1247053harbour
haviour1354823haviour
honour94710863hon_our
indoor738403_indoor
inpour837063_inpour
labour84210933la_bour
landau7310613landau_
landaus8310343landaus
lander74028483land_er
landler84113203landler
languor895423languor
langur7109303lan_gur
mandola1039023mandola
manor78023933man_o_r
odour64710493__odour
padauk1335643pa_dauk
padder103415493pa_dder
paddler113711553paddler
paddock17104733paddock
padouks1434873pa_douks
pallor8313673pallo_r
panda85022613pand__a
pandani1039903pandani
pandanus1136433pandanus
pandas95521963pand_as
pandect12310953pandect
panderer112210913panderer
panders103423733panders
pandied113913443pandied
pandies104224503pandies
pandit93820753pand_it
pandits103914213pandits
pandoras11310053pandoras
pandores11312453pandores
pandowdy1842143pandowdy
panduras1136953pand_uras
pandy115021173pand__y
panful1179743pan_ful
panicum1346393panicum
panier84425503pan_ier
panner84224763pan_ner
pannier93613353pannier
panther12611443panther
panto76129413panto__
pantos85222743panto_s
pantoums1236713pantoums
panzer174213233pan_zer
pappous1057463pappous
parador103311413parado_r
paramour1246083paramour
pardner10239473pardner
pardon94618733pardo_n
pardoner11189443pardoner
pardons103817623pardons
parlor8312673parlo_r
parlours1036153parlours
parlous9414293parlous
parous84024163pa_rous
pastor84817483pasto_r
pavior1138533pavio_r
paviours1343613paviours
pawnor11357243pawno_r
payor105413843pa_yo_r
payout11714653pa_yout
pinder94523453pind_er
ponder94521693pond_er
pour611527473p___our
rancor8810373ranco_r
rancours1076713rancours
randier83618473randier
random92513553rando_m
randoms102112433randoms
sandbar10108193sandbar
sandburr11123223sandburr
sandburs11105623sandburs
sander74828533sand_er
sandier84017843sandier
sandspur1142403sandspur
sanious7514103sanious
santoor737433santoor
santours837183santours
santur6311273san_tur
sapour83812373sa_pour
saviour1035213saviour
savour94110703sa_vour
splendour1252223splendour
standout948663standout
tabour84011323ta_bour
tambour1136353tambour
tandoori9244773tandoori
tandoors9258053tandoors
tenour62610733ten_our
undoer73113043_undoer
valour93010373va_lour
vanadous1246033vanadous
vapour11378873va_pour
vendor10359803vendo_r
wander104423713wand_er
zander163417113zand_er

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.406440125.6
2DLD Change Limit1340271626.23321502.8
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.70226662.3
 
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.