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

141 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
parlours103615(None) 
parlors9312911parlo_rs
parlour937261parlour_
parlous9414291parlou_s
arbours93910042_arbours
ardours8368882_ardours
armours9389852_armours
harbours1346922harbours
pallors9314362pallo_rs
pandours11317992pandours
paramours1345652paramours
parlor8312672parlo_r_
parous84024162par_ou_s
paviours1343612paviours
valours10248742va_lours
amours83512663_a_mours
arbors84717883_arbo_rs
arbour84211333_arbour_
ardors74416873_ardo_rs
ardour74110903_ardour_
armors85017813_armo_rs
armour84411853_armour_
armoury12376233_armoury
bailors93212413bailo_rs
bailouts1036613bailouts
barlows12259973barlo_ws
callous93516603callou_s
candours11408643candours
carious93320283cariou_s
carloads1138393carloads
carolers103314173carolers
carolus94612603carolu_s
clours85215093__clours
colours95913443_colours
dolours8438823_dolours
earlobes1056143earlobes
earlocks1435693earlocks
faitours1134263faitours
fallouts1137883fallouts
farceurs13464723farceurs
favours13437093fa_vours
fervours1453053fervours
flours94414053__flours
gallous82813953gallou_s
harbors12412413harbo_rs
harbour1247053harbour_
harlotry1443403harlotry
harlots103413293harlo_ts
haviours1443843haviours
jailors14328753jailo_rs
labours9349893la_bours
lours55125293___lours
oarlocks1445103oarlocks
pablums1345123pabl_ums
padlocks1755473padlocks
padouks1434873pa_douks
pailfuls1343843pailfuls
palliums1236703palliums
pallor8313673pallo_r_
palmers113513623pa_lmers
palpus104210283pa_lpu_s
palters94021683pa_lters
pandoors11258983pandoors
pandour10408213pandour_
pantoums1236713pantoums
pappous1057463pappou_s
paraders113113113paraders
paradors113411903paradors
paramour1246083paramour_
parboils1237433parboils
parcloses1347963parcloses
pardners11269193pardners
pardoners12208213pardoners
pardons103817623pardo_ns
pareos87023773pareo__s
parers85530743par__ers
pareus85420743par_eu_s
pargos95719043pargo__s
parkers133816873par_kers
parlays123910453parl_ays
parles86334403parl__es
parleyers1444703parleyers
parleys125212373parl_eys
parlously1445663parlously
parodos103011753par_odos
parolees104313983parolees
paroles95025883par_oles
parols84722613par_o_ls
parriers103612903parriers
parroters1156763parroters
parrots9312743parro_ts
parrs75928673par___rs
parsers94118153par_sers
parsons93516873parso_ns
partiers103514243partiers
partners102711133partners
partons94620513parto_ns
partyers13277763partyers
parura8310583par__ura
paruras9310533par__uras
parure8312523par__ure
parures9512693par__ures
parvos116614753parvo__s
pastors94119003pasto_rs
patulous10116363patulou_s
paviors1237603pavio_rs
paviour1244623paviour_
pavlovas1642423pavlovas
pawnors12297203pawno_rs
payloads1445293payloads
payors114312643pa_yo_rs
payouts1247303pa_youts
pearlers1039033pearl_ers
pelorus939273p_elorus
perilous10310693perilou_s
pilous84717753p_ilou_s
porous84419483por_ou_s
pours74623183p___ours
priors83914483p_rio_rs
pullouts1045223pullouts
purloins1077033purloins
pylorus1235333p_ylorus
rancours1076713rancours
sailors73213723sailo_rs
santours837183santours
sapours93610623sa_pours
sarcous9312933sarcou_s
sartors7314973sarto_rs
saviours1154273saviours
savours10389343sa_vours
tabours94110093ta_bours
tailors73212393tailo_rs
tambours1255873tambours
valors93413773va_lo_rs
valour93010373va_lour_
vapours12277463va_pours
various103113103variou_s
velours10278083_velours
warlocks1735363warlocks
warlord1136293warlo_rd
warlords1245303warlords

Search took 10 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.403443402.0
2DLD Change Limit1461621418.55017095.0
3Display Results1411410.0761855.3
 (SQL Overall)1786911419.02919790.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.