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

184 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
pectize2025991(None) 
pectized22257591pectized
pectizes21229781pectizes
peptize20279481peptize
pectase112410362pectase
pectate112214692pectate
pectic122913872pecti_c
pectin102615532pecti_n
pectines121914682pectines
pectins112315232pectins
peptide122910682peptide
peptized22237512peptized
peptizer21236472peptizer
peptizes21269852peptizes
petite84320652pe_tite
poetize18310772poetize
sectile9311972sectile
tectite9310582tectite
active11313743_active
agatize1739833agatize
azotize1537083azotize
baptize2036983baptize
becrime1387053becrime
bedtime1236973bedtime
betide95115973be_tide
betime105914833be_time
betise85616273be_tise
centile94217183centile
centime114513033centime
cyclize2345403cyclize
deceive1337813deceive
decide104116873dec_ide
decile94619213dec_ile
decline103716613decline
dentine83320243dentine
deputize2045423deputize
destine83719953destine
ductile1048483ductile
ectype1334283_ectype
ejective2037153ejective
elective13311003elective
entice81316863_entice
entire61617703_entire
erectile1039513erectile
erective13311833erective
erotize16311663erotize
expertize2746583expertize
fertile10311733fertile
festive1339773festive
fictile1238023fictile
fictive1537023fictive
gentile83515293gentile
grecize1935663grec_ize
hectare1238463hectare
hectic132311523hecti_c
hepatize2248233hepatize
heroize193210963heroize
lectin82515013lecti_n
lectins92515003lectins
lection92614863lection
lecture9149513lecture
mestiza1835383mestiza
mestizo1845943mestizo
necktie1344363neckti_e
necrotize2046473necrotize
netizen1635883ne_tizen
orective1339353orective
paction112713963paction
pantie84326473panti_e
pantile93918483pantile
partite9317133partite
pastie85525523pasti_e
pastime114611973pastime
patine85328123p_atine
pattie84020963patti_e
peacetime1544473peacetime
pealike131211273pealike
peatier94017233peatier
peching154513903peching
peckier153910523peckier
pecking164017783pecking
peckish18227293peckish
pectases122411193pectases
pectates122213953pectates
pecten102711103pect_en
pectens11189203pectens
pectinate1349553pectinate
pectizing2348013pectizing
peerie83617893peeri_e
peglike14136773peglike
peise75825773pe__ise
pelite84323003pe_lite
pelletize2056383pelletize
peltate92013773peltate
pelting102917273pelting
penalize19912753penalize
penile82219603pe_nile
penlite9313243penlite
pennine93712953pennine
pensile92713543pensile
pensive122610393pensive
pentane9415743pentane
pentene9313793pentene
pentode1039893pentode
pentose9311593pentose
pepsine11310603pepsine
peptic122113153pepti_c
peptics132610243peptics
peptid112712373pepti_d
peptides132610263peptides
peptids12239323peptids
peptizers22245033peptizers
peptone11310763peptone
peptonize2246563peptonize
perceive1546973perceive
perdie94718513perdi_e
perlite9317313perlite
pestier94317403pestier
pestle83215843pest_le
petiole9311303pe_tiole
petit74332653pe_ti_t
petites93820203pe_tites
petti75119453petti__
pettier94213613pettier
pettily1238173pettily
petting103720953petting
pettish1238283pettish
pettle84116053pe_ttle
picrite111911313picrite
picture1158613picture
picturize2244463picturize
pintsize1955103pintsize
poetise9314043poetise
poetized2037983poetized
poetizer1936813poetizer
poetizes19310253poetizes
pontine92419053pontine
postie84123963posti_e
poutine93316823poutine
practice1438733practice
practise12310143practise
precative16312573precative
precipe133012123prec_ipe
precise113518173prec_ise
preconize2268633preconize
prentice121012353prentice
prestige11310733prestige
prize164718943p__rize
puttie84116303putti_e
reactive13310473reactive
realize162717083realize
receive1239733receive
recipe103414893rec_ipe
recite83625113rec_ite
recline94020493recline
recti73619623recti__
rectify1536453rectify
reptile93914083reptile
reseize1639553reseize
resize154117723re_size
restive10315933restive
retie55735303re_ti_e
retile65929673re_tile
retime85321803re_time
retine66237333re_tine
retire64927013re_tire
section92515663section
seize143819503se__ize
septime1138803septime
sestine73017923sestine
sextile1438573sextile
smectite1245773smectite
specie10412223spec_i_e
spectate12248833spectate
spectre11297773spect_re
tactile9310613tactile
teatime9310083teatime
techie11511723techi_e
tectites1039993tectites
tektite1136883tektite
tentie62521183tenti_e
textile1437223textile
unitize16310033unitize
vestige1137433vestige

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.1561145455.1
2DLD Change Limit1340271847.43618024.1
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.65523343.0
 
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.