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

139 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
peculated14231085(None) 
peculate122414671peculate_
peculates132112541peculates
speculated15186611speculated
emulated11310792_emulated
jaculated19289052jaculated
loculated1288312loculated
maculated142411502maculated
operculated1645152operculated
osculated1298142osculated
peculator1387862peculator
percolated1548252percolated
populated14228802populated
regulated11310462regulated
speculate13239192speculate_
speculates14237902speculates
tegulated1146632tegulated
aculeated1247723_aculeated
acylated1437873_acylated
adulated1039753_adulated
ambulated1457133ambulated
angulated1139223angulated
annulated1038603annulated
apiculate13279883apiculate_
arcuated1138803arcu_ated
belated103520013be__lated
calculated1577803calculated
canulated12310673canulated
circulated1588063circulated
copulated142710483copulated
crenulated1356043crenulated
cumulated14237843cumulated
curated104717583__curated
dealated103213603de_alated
decimated1548953decimated
declared1248743dec_lared
declawed1545923dec_lawed
decollated14136283decollated
decorated13312203decorated
decussated1442893decussated
deflated133412303de_flated
delated93722873de__lated
denudated1244933denudated
depilated1339653depilated
depurated1338183depurated
desolated1139653desolated
educated1237943_educated
ejaculated20165903ejaculated
elated74725823_e__lated
emulate9314123_emulate_
emulates10312573_emulates
epilated11310753_epilated
equated171910403_equ_ated
escalated1247303escalated
exculpated2243923exculpated
exulted1536303_exul_ted
fabulated1546323fabulated
feculae12339203fecula_e_
fecundated1741993fecundated
fellated1239563fe_llated
gelated93615633ge__lated
geniculated1544643geniculated
incubated1446983incubated
inculcated1546173inculcated
inculpated1545733inculpated
inoculated1347593inoculated
insulated10310713insulated
jaculate172311783jaculate_
jaculates182810363jaculates
jugulated1844023jugulated
ligulated11247363ligulated
lobulated12106423lobulated
loculate101011403loculate_
lunulated1036783lunulated
maculate122815623maculate_
maculates132013723maculates
medullated1442993medullated
mercurated1545393mercurated
modulated1336713modulated
necklaced1842593necklaced
occulted1344263occul_ted
ocellated1245453ocellated
operculate1446253operculate_
osculate101010613osculate_
osculates11109393osculates
ovulated1237083_ovulated
pectate112214693pec_tate_
pectates122213953pec_tates
peculating1549153peculating
peculation14311993peculation
peculators1486983peculators
pediculate1546613pediculate_
pediculates1645683pediculates
pedunculated1851973pedunculated
pelleted1138203pe_lleted
pelted94617763pe__l_ted
pennated11299543pe_nnated
percolate13411163percolate_
percolates14410423percolates
permeated1439373permeated
perorated12412463perorated
phenolated1645253phenolated
picrated132110113pic_rated
pixilated1944543pixilated
plated95225773p___lated
populate122812093populate_
populates132710673populates
postulated1377653postulated
pullulated1343253pullulated
pulsated1136853p__ulsated
pupated12319353p__upated
pustulated1375543pustulated
recoated113416783rec_oated
recrated112918603rec_rated
recreated12412533recreated
reflated123514293re_flated
regelated1139723regelated
regulate9313023regulate_
regulates101211723regulates
related83327573re__lated
replated112817523re_plated
resculpted1543223resculpted
reslated93517523re_slated
resulted939713resul_ted
reticulated14127783reticulated
sacculated1546623sacculated
sculpted1354883_sculpted
simulated1238283simulated
speciated14207543spec_iated
spectated14236593spec_tated
speculator1484883speculator
spiculate132210163spiculate_
sporulated1345263sporulated
tabulated1237303tabulated
tubulated1256063tubulated
ululated947663_ululated
undulated11310083undulated
vacuolated1643973vacuolated
vesiculated1745553vesiculated

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411397.37320160.2
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.85922737.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.