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

151 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
pandours1131799(None) 
candours11408641candours
pandoors11258981pandoors
pandour10408211pandour_
ardours8368882_ardours
candors104216762cando_rs
candour104210242candour_
handouts1238232handouts
padouks1434872pa_douks
panders103423732pand_ers
pandoor10358582pandoor_
pandora1039542pando_ra
pandoras11310052pandoras
pandore10411852pando_re
pandores11312452pandores
pandura1037142pand_ura
panduras1136952pand_uras
pantoums1236712pantoums
parlours1036152parlours
paviours1343612paviours
rancours1076712rancours
sandburs11105622sandburs
santours837182santours
tandoors9258052tandoors
adnouns835453_adnouns
amours83512663_a_mours
apodous1037403apodou_s
arbours93910043_arbours
ardors74416873_ardo_rs
ardour74110903_ardour_
armours9389853_armours
banders104324563band_ers
bandogs1138363bando_gs
bandora1038813bando_ra
bandoras1138743bandoras
bandore10611633bando_re
bandores11311603bandores
candlers114214103candlers
candor94516423cando_r_
canoers94318373can_oers
cantors94620753canto_rs
clangours12263123clangours
concours1239473concours
condors104018573condo_rs
contours1039653contours
danders93921183dand_ers
dandlers103912053dandlers
danseurs933433danseurs
enamours1044663enamours
expandors19142833expando_rs
faitours1134263faitours
fandoms13229473fando_ms
favours13437093fa_vours
ganders93521703gand_ers
grandeurs11335113grandeurs
handcars1437623handcars
handers114224333hand_ers
handfuls15115753handfuls
handguns1344363handguns
handlers124014143handlers
handoffs1844733handoffs
handout11314103handou_t
handovers16136183handovers
hangouts1236183hangouts
harbours1346923harbours
haviours1443843haviours
honours10339373hon_ours
indoors838553_indoors
inpours936423_inpours
labours9349893la_bours
landaus8310343landau_s
landers84026213land_ers
landlers94312833landlers
languors976153languors
langurs889103lan_gurs
mandolas1139133mandolas
manors84420883man_o_rs
odours7418253__odours
padauks1443943pa_dauks
padders113312873pa_dders
paddlers12329153paddlers
paddocks1894323paddocks
padouk1336683pa_dou_k
pallors9314363pallo_rs
pandanus1136433pandanus
pandas95521963pand__as
pandects1335843pandects
pander93725523pand_er_
panderers12229153panderers
pandies104224503pand_ies
pandits103914213pand_its
pandowdy1842143pandowdy
panfuls1237173pan_fuls
panicums1444743panicums
paniers94717333pan_iers
panners93621273pan_ners
panniers10488853panniers
panthers13510783panthers
pantos85222743panto__s
pantoum1138703pantou_m
panzers184012013pan_zers
pappous1057463pappou_s
paradors113411903parado_rs
paramours1345653paramours
pardners11269193pardners
pardoners12208213pardoners
pardons103817623pardo_ns
parlors9312913parlo_rs
parlour937263parlour_
parlous9414293parlou_s
parous84024163pa_rou_s
pastors94119003pasto_rs
paviors1237603pavio_rs
paviour1244623paviour_
pawnors12297203pawno_rs
payors114312643pa_yo_rs
payouts1247303pa_youts
pinders103720473pind_ers
ponders103618843pond_ers
pours74623183p___ours
rancors9811373ranco_rs
rancour987133rancour_
randoms102112433rando_ms
sandbars11108783sandbars
sandbur10105353sandbur_
sandburr11123223sandburr
sandburrs12112783sandburrs
sanders84025943sand_ers
sandspurs1242583sandspurs
sanious7514103saniou_s
santoors837633santoors
santour737373santour_
santurs7310763san_turs
sapours93610623sa_pours
saviours1154273saviours
savours10389343sa_vours
splendours1351843splendours
standouts1044983standouts
tabours94110093ta_bours
tambours1255873tambours
tandoor8278563tandoor_
tandoori9244773tandoori
tandooris10224633tandooris
tenours72610073ten_ours
undoers82910583_undoers
valours10248743va_lours
vanadous1246033vanadou_s
vapours12277463va_pours
vendors113510223vendo_rs
wanders114221333wand_ers
zanders173015793zand_ers

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 Limit1461621517.20320291.8
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.68923239.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.