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

117 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
pectized2225759(None) 
pectize20259911pectize_
pectizes21229791pectizes
peptized22237521peptized
pectines121914682pectines
peptize20279482peptize_
peptizer21236472peptizer
peptizes21269852peptizes
poetized2037982poetized
agatized1947073agatized
azotized1745673azotized
baptized2245483baptized
becrimed1565513becrimed
betided114810203be_tided
cyclized2544943cyclized
deceived1535893deceived
decided124312423dec_ided
declined123910883declined
decried112612853decri_ed
dentiled1039743dentiled
deputized2244333deputized
destined103312453destined
enticed101411193_enticed
erotized1838553erotized
expertized2944713expertized
grecized2134433grec_ized
hectored1436883hectored
hepatized2446253hepatized
heroized21298453heroized
jettied15366973jetti_ed
lectured11127233lectured
necrotized2245083necrotized
netizen1635883ne_tizen
pantiled113111593pantiled
partied103516553parti_ed
patined105114783p_atined
pearlized2145563pearlized
peatier94017233peati_er
peched144915343pec__hed
pecked155019103pec__ked
peckier153910523pecki_er
pectase112410363pectase_
pectases122411193pectases
pectate112214693pectate_
pectates122213953pectates
pecten102711103pect__en
pectic122913873pecti__c
pectin102615533pecti__n
pectins112315233pecti_ns
pectizing2348013pectizing
peined94918843pe__ined
peised94817683pe__ised
pelletized2244993pelletized
pelted94617763pelt__ed
peltered112510453peltered
penalized211210243penalized
penciled1337823penciled
peptid112712373pepti__d
peptide122910683peptide_
peptides132610263peptides
peptizers22245033peptizers
peptonized2455573peptonized
perceived1744353perceived
periled10316323pe_riled
pertained1238503pertained
pestered112814973pestered
pestier94317403pesti_er
pestled102711453pest_led
petaled103614153pe_taled
petered103314973pe_tered
petioled1137993pe_tioled
petite84320653pe_tite_
petites93820203pe_tites
petted94121523pe_t_ted
pettier94213613petti_er
pettled103611513pe_ttled
pictured1346573pictured
picturized2443683picturized
pintsized2153673pintsized
pitied94017253p_iti_ed
plotzed19376223plot_zed
poetised1138523poetised
poetize18310773poetize_
poetizer1936813poetizer
poetizes19310253poetizes
practiced1655113practiced
practised1446103practised
precised133213413prec_ised
precited133013813prec_ited
preconized2467143preconized
prenticed14118063prenticed
prettied1159253pretti_ed
prized184415393p__rized
puttied103811163putti_ed
putzed18409113p_ut_zed
realized182514223realized
received1437983received
recited104319103rec_ited
reclined113613603reclined
recoiled113613213recoiled
recoined113614423recoined
rectified1539243rectified
reseized1839213reseized
resized174614903re_sized
retied75924983re_ti_ed
retiled84420513re_tiled
retimed104714653re_timed
retired84620143re_tired
sectile9311973sectile_
sectioned1246523sectioned
sectored1138073sectored
seized164313653se__ized
spectated14236593spectated
tectite9310583tectite_
tectites1039993tectites
unitized1839233unitized
vectored1435633vectored

Search took 9 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 Limit1461621177.70318974.7
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.17221866.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.