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

165 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
parlour93726(None) 
parlor8312671parlo_r
parlours1036151parlours
parlous9414291parlous
arbour84211332_arbour
ardour74110902_ardour
armour84411852_armour
harbour1247052harbour
pallor8313672pallo_r
pandour10408212pandour
paramour1246082paramour
parlors9312912parlors
parous84024162par_ous
paviour1244622paviour
valour93010372va_lour
aloud65018073_a_loud
amour75014853_a_mour
arbor74818113_arbo_r
arbours93910043_arbours
ardor64617863_ardo_r
ardours8368883_ardours
armor75118053_armo_r
armours9389853_armours
armoury12376233_armoury
bailor83412603bailo_r
bailout9414133bailout
barlow112911433barlo_w
barlows12259983barlows
callous93516603callous
candour104210243candour
carious93320283carious
carload1039783carload
caroler93816753caroler
carolus94612603carolus
clour76617283__clour
colour85915093_colour
dolour75710133_dolour
earlier72612743earlier
earlobe946553earlobe
earlock1336923earlock
faitour1034883faitour
fallout10313503fallout
farceur12525273farceur
favour12438333fa_vour
fervour1343103fervour
flour84916453__flour
gallous82813953gallous
harbor11410723harbo_r
harbours1346923harbours
harlot94422803harlo_t
harlotry1443403harlotry
harlots103413293harlots
haviour1354823haviour
jailor13418573jailo_r
labour84210933la_bour
lour45430683___lour
marlier92614783marlier
oarlock1336123oarlock
pablum1237503pabl_um
padlock1665813padlock
padouk1336683pa_douk
pailful1236103pailful
paler75436933pa_l_er
palier85023563pa_lier
pallier94417163pallier
pallium1149013pallium
pallors9314363pallors
palmar104113463pa_lmar
palmer105816543pa_lmer
palpus104210283pa_lpus
palter84423263pa_lter
pandoor10358583pandoor
pandours11317993pandours
pantoum1138703pantoum
pappous1057463pappous
parader103914863parader
parador103311413parador
paramours1345663paramours
parboil1138323parboil
parclose1247243parclose
pardner10239473pardner
pardon94618733pardo_n
pardoner11189443pardoner
pardons103817623pardons
pareo74632603pareo__
pareos87023773pareo_s
parer75839903par__er
pareu74928743par_eu_
pareus85420743par_eus
pargo86723723pargo__
pargos95719043pargo_s
parker124121373par_ker
parlay113713993parl_ay
parlays123910453parlays
parle75836163parl__e
parled94626293parl_ed
parles86334413parl_es
parley116718363parl_ey
parleyer1335633parleyer
parleys125212383parleys
parling103823763parling
parlously1445663parlously
parody12410093par_ody
parol74826273par_o_l
parole84425253par_ole
paroled104217633paroled
parolee94119653parolee
paroles95025893paroles
parols84722613par_ols
parr65731153par___r
parrier93717653parrier
parrot8320663parro_t
parroter1058213parroter
parrots9312743parrots
parroty1247863parroty
parser84822373par_ser
parson83817903parso_n
parsons93516873parsons
partier93520713partier
partner92811393partner
parton84720993parto_n
partons94620513partons
partook1337313partook
partyer12337873partyer
parura8310593par__ura
parure8312523par__ure
parvo107719183parvo__
parvos116614753parvo_s
pastor84817483pasto_r
patulous10116363patulous
pavior1138533pavio_r
paviours1343613paviours
pavlova1542113pavlova
pawnor11357243pawno_r
payload1336403payload
payor105413843pa_yo_r
payout11714653pa_yout
pearler9310373pearl_er
pearlier1037323pearlier
perilous10310693perilous
pilous84717753p_ilous
porous84419483por_ous
pour611527473p___our
prior74316173p_rio_r
proud84615483p_r_oud
pullout9310593pullout
purloin9107493purloin
rancour987133rancour
sailor63113753sailo_r
santour737373santour
sapour83812373sa_pour
sarcous9312933sarcous
sartor6313883sarto_r
saviour1035213saviour
savour94110703sa_vour
tabour84011323ta_bour
tailor63412503tailo_r
tambour1136353tambour
valor83614893va_lo_r
valours10248743va_lours
vapour11378873va_pour
various103113103various
velour9328763_velour
warlock1636293warlock
warlord1136293warlord

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271656.89319443.9
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.34324334.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.