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

142 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
partook133731(None) 
caretook1445172caretook
cartoon94114462cartoon
parton84720992part_on
partons94620512partons
patroon92811972patroon
artwork1447083_artwork
barroom1139373barroom
barstool1044233barstool
betook12439603_betook
brook114717763_br_ook
cardoon104813813cardoon
carpool1139223carpool
carton84522663cart_on
cartons94122473cartons
cartoons104012803cartoons
cartoony13377403cartoony
cartop104213563cart_op
crook115217573_cr_ook
daybook1744373daybook
earlock1336923earlock
fartlek1434493fartlek
forsook1446003forsook
harpoon1238313harpoon
jargoon1545193jargoon
karoo92519583kar_oo_
karoos102415803kar_oos
karroo10410013karroo_
karroos1139313karroos
lardoon83410373lardoon
lawbook1644033lawbook
maroon83118203mar_oon
mattock1535823mattock
mistook1337153mistook
oarlock1336123oarlock
overtook15106053overtook
paction112713963paction
paddock17104733paddock
padlock1665813padlock
padouk1336683pa_douk
palooka1344503pa_looka
pandoor10358583pandoor
panto76129413pant_o_
pantos85222743pant_os
pantoum1138703pantoum
parador103311413parador
parados103816053parados
paradox17358173paradox
paragon10311023paragon
paramo102614643paramo_
paramos113213513paramos
parasol939553parasol
paratroop1352993paratroop
parboil1138323parboil
pardon94618733par_don
pardons103817623pardons
pareo74632603par_eo_
pareos87023773par_eos
pargo86723723par_go_
pargos95719043par_gos
park105237493par___k
parlor8312673par_lor
parlors9312913parlors
parlour937263parlour
parlous9414293parlous
parodoi10267723parodoi
parodos103011753parodos
parody12410093par_ody
parol74826273par__ol
parole84425253par_ole
parols84722613par_ols
parotic112518043parotic
parotid102915513parotid
parotoid11410033parotoid
parous84024163par_ous
parrot8320663par_rot
parrots9312743parrots
parroty1247863parroty
parson83817903par_son
parsons93516873parsons
part65967463part___
partake1339643partake
partan83820563part_an
partans94418283partans
parted94228683part_ed
partial92616263partial
partied103516553partied
partier93520713partier
parties93230863parties
parting103527383parting
partita9310863partita
partite9317133partite
partlet92720363partlet
partly116315473part_ly
partner92811393partner
parts77743373part__s
partway1535923partway
party106630613part__y
partyer12337873partyer
parvo107719183par_vo_
parvos116614753par_vos
passbook1643283passbook
pastor84817483past_or
pastors94119003pastors
pathos115516693pa_thos
patio74426353pa_tio_
patios85221783pa_tios
patois84319363pa_tois
patriot9314533patriot
patrol83213023pa_trol
patrols93513513patrols
patron84018043pa_tron
patrons93818103patrons
patroons102710603patroons
pearwood1444833pearwood
platoon938953platoon
playbook1943463playbook
pontoon93010703pontoon
portion9615493portion
pothook1656883pothook
prebook1557523prebook
precook1577803precook
proof105221533p_r_oof
proton84318893p_roton
ratoon64417373ra_toon
rattoon7359243rattoon
retook104313443_retook
rook85532033__r_ook
santoor737433santoor
sartor6313873sart_or
sartors7314963sartors
stook95218213__stook
strook10410303str_ook
tarok97921073tar__ok
tattoo6310973tattoo_
tattoos738643tattoos
took86531073___took
varoom11411413var_oom
warlock1636293warlock
warthog1444533warthog
warwork1757573warwork
yearbook1742743yearbook

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.1401276364.3
2DLD Change Limit1340271426.06322105.7
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.24928595.1
 
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.