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

248 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
picrates12201321(None) 
picrate112014141picrate_
picrated132110111picrated
picrites121811081picrites
pirates93020331pi_rates
citrates102315092citrates
crates85736062__crates
dictates11311382dictates
disrates91118152disrates
librates103412952librates
migrates111112852migrates
misrates101318242misrates
nictates1039592nictates
nitrates82516222nitrates
pectates122213952pectates
phorates13413042phorates
pickaxes2344912pickaxes
picrite111911312picrite_
pirate82322882pi_rate_
pirated102515612pi_rated
prates84633162p__rates
priorates11410762priorates
prorates10418072prorates
recrates102420372recrates
titrates82314662titrates
uncrates10314562uncrates
vibrates132210612vibrates
vicarates1487622vicarates
accretes1238113accretes
acierates11310813acierates
aerates74627493_aerates
airdates939723airdates
amirates101114793amirates
aspirates1139613aspi_rates
berates94126873_berates
borates94823013_borates
carates95630613_carates
cartes86239473__cartes
cates75951893__c_ates
cerates95428253_cerates
ciliates10413453ciliates
cirrate92413493cirrate_
citrate92216803citrate_
citrated112712253citrated
cocreates132611883cocreates
crakes124921813__crakes
cranes84330753__cranes
crapes104727693__crapes
crases85532313__crases
crate76537403__crate_
crated94827773__crated
crater85026643__crater
craters95021893__craters
craves115825393__craves
crazes174720133__crazes
creates95225203__creates
curates95323833_curates
decorates12314743decorates
derates84028893_derates
dictate10311663dictate_
dictated1239203dictated
dilates83220663di_lates
diorites9313523diorites
disrate81418523disrate_
disrated10915573disrated
ecartes94212563_ecartes
emigrates1248583emigrates
emirates101214853emirates
ephorates1459163ephorates
epilates10313503epi_lates
eucrites1049483eucrites
excretes1787573excretes
execrates1839563execrates
ferrates113013423ferrates
filiates11412663filiates
filtrates1247733filtrates
fixates1737393fi_xates
furcates1339883furcates
grates75429893__grates
gyrates113610263_gyrates
hydrates15229413hydrates
ideates8313733_ideates
ingates82716913_ingates
ingrates9514173ingrates
inmates92715783_inmates
iodates8312903_iodates
irades74517393_i_rades
irate55627983_i_rate_
irater65218353_i_rater
iratest7312483_i_ratest
iterates81317823iterates
karates115617473_karates
lacerates112413773lacerates
lactates10311223lactates
liberates111012943liberates
librate93214233librate_
librated113110313librated
ligates82318383li_gates
liquates1737453liquates
literates91415653literates
locates93218813loc_ates
macerates132113573macerates
macrames1438953macrames
microbes1439403microbes
micturates1456093micturates
migrate101314173migrate_
migrated121110513migrated
mirages102213533mi_rages
miscreates1448103miscreates
misdates111113633misdates
mismates121114563mismates
misrate91319143misrate_
misrated111315383misrated
narrates8312763narrates
nictate9310223nictate_
nictated1137793nictated
nidates8311893ni_dates
niobates1037283niobates
nitrate72017013nitrate_
nitrated92213153nitrated
nitrites82313453nitrites
operates10515413operates
opiates9312143opi__ates
orates64328613__orates
outrates82421373outrates
packages17138733packages
palates93624933p_alates
palpates122613063palpates
parades104121463p_arades
pates76047893p___ates
patriates11311363patriates
pectases122411193pectases
pectate112214693pectate_
peculates132112543peculates
peerages1189893peerages
penates93321603p_enates
percales12313803percales
perorates11417023perorates
petrales10312983petrales
phenates13611583phenates
phonates13410643phonates
phorate12413363phorate_
phrases12711463p_hrases
picante11310523picante_
picaras11311283pic_aras
picaros11310893pic_aros
picas94626523pic_a__s
piccata1345703piccat_a
pickaxe2244623pickaxe_
pickaxed2443513pickaxed
picketed17167383picketed
picketer16187433picketer
picketers17196483picketers
pickets154314183picket_s
pickles153215443pic_kles
picoted1239213pic_oted
picotee11311473pic_otee
picotees1247113picotees
picots104616443pic_ot_s
picowaves19102893picowaves
picquets2143733picquets
picritic1448263picritic
pictures1249343pictures
pierces113411193pier_ces
pikakes1245823pi_kakes
pileate93815923pileate_
pileated112711133pileated
pillages113012613pillages
pinatas93711503pi_natas
pinites9319533pi_nites
pinnaces12268863pinnaces
pinnate93613743pinnate_
pinnated11338553pinnated
pinwales1367963pinwales
pipages1289423pi_pages
pipeages1336423pipeages
pipettes1237563pipettes
piracies12312643pi_racies
piranas9912603pi_ranas
piratic11314293pi_ratic
pirayas1277483pi_rayas
piscaries13410073piscaries
pistes85325633pi__stes
pizzazes1752513pizzazes
placates12311753placates
plates85432243p__lates
plicate11314513plic_ate_
plicated13310643plic_ated
prases84429023p__rases
prate75135983p__rate_
prated94924923p__rated
prater84825353p__rater
praters94921653p__raters
prats76333393p__rat_s
praxes156215183p__raxes
predates11615813predates
prelates10418573prelates
primates121515933primates
priorate10411733priorate_
privates131812373privates
probates12414283probates
procreates1448153procreates
pronates10418373pronates
prorate9418733prorate_
prorated11513713prorated
pulsates1048813pulsates
pupates113311433p_upates
pyrites12812203p_yrites
rates55352013___rates
recrate92621663recrate_
recrated112918603recrated
recreates11313363recreates
regrates92618403regrates
ricracs1136363ricra_cs
scrapes116217663_scrapes
secretes10410473secretes
serrates82617023serrates
sinuates8310963sinuates
situates8310373situates
speciates13229233speciates
spectates13228813spectates
spicate113214193spic_ate_
spicated13309903spic_ated
spiccatos1553253spiccatos
sucrases10310253sucrases
tirades8311723ti_rades
titrate72215573titrate_
titrated92611683titrated
ulcerates1148853ulcerates
uncrate9415953uncrate_
uncrated11416313uncrated
uncreates11310433uncreates
uprates93814863_uprates
urates65027763__urates
vacates12312833vac_ates
vibrate122811523vibrate_
vibrated14228393vibrated
vibratos13217483vibratos
vicarages1574433vicarages
vicarate1378603vicarate_
vicariates1565533vicariates
vicomtes1545593vicomtes
violates11311193violates
virgates1237923virgates
vitiates112311433vitiates
vizirates2144663vizirates
wickapes1943703wickapes
zincates1937743zincates

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622486.47022590.7
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.96925640.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.