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

106 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
peculation1431199(None) 
peculations15310281peculations
speculation1547541speculation
emulation11312392_emulation
maculation14510982maculation
osculation1249672osculation
peculating1549162peculating
peculator1387862peculat_or
percolation1549222percolation
population14810022population
regulation11312052regulation
speculations1646392speculations
spiculation1547032spiculation
accusation1466903accusation
acylation1448653_acylation
adulation10311013_adulation
ambulation1447873ambulation
angulation1149553angulation
annulation1068953annulation
arcuation11410583arcu_ation
calculation1548293calculation
circulation1549393circulation
copulation141111953copulation
crenulation1347573crenulation
cumulation1448173cumulation
dealation10313003de_alation
decimation15411623decimation
decollation1448193decollation
decoration13314423decoration
decussation1444303decussation
deflation13310653de_flation
delation92318083de__lation
denudation1247303denudation
depilation13312033depilation
deputation1339393deputation
desolation11311403desolation
education12310203_education
ejaculation2096133ejaculation
elation73620453_e__lation
emulations12310943_emulations
epilation11312963_epilation
equation17310483_equ_ation
escalation1248873escalation
exculpation2244873exculpation
exudation1787693_exudation
exultation1747533_exultation
fecundation1743573fecundation
fellation1238843fe_llation
gelation93014433ge__lation
incubation1448363incubation
inculcation1557243inculcation
inculpation1546773inculpation
inoculation1358713inoculation
insulation10311663insulation
lobulation1247233lobulation
maculations1569623maculations
mercuration1547493mercuration
modulation13147933modulation
morulation12148903morulation
neurulation1145343neurulation
nodulation11127993nodulation
occultation1545133occultation
occupation1645183occupation
osculations1348373osculations
ovulation1238983_ovulation
pectination15410333pectination
peculate122414673peculat__e
peculated142310853peculat_ed
peculates132112543peculat_es
peculators1486983peculators
peltation11312963pe_ltation
percolations1648053percolations
permeation14410563permeation
permutation1547473permutation
peroration12316003peroration
pixilation1945913pixilation
populations15148713populations
postulation13119133postulation
procuration1548293procuration
pullulation1343343pullulation
pulsation1137143p__ulsation
pupation1269503p__upation
pustulation13116623pustulation
recitation12315943recitation
recreation12413613recreation
reflation12412333re_flation
refutation1349913refutation
regulations12310713regulations
relation82619773re__lation
reputation12411883reputation
reticulation1448053reticulation
revelation13410923revelation
sacculation1547843sacculation
scalation11311073_scalation
simulation1269583simulation
speciation1449393spec_iation
speculating1645943speculating
speculative1844273speculative
speculator1484883speculat_or
spiculations1646173spiculations
sporulation1346403sporulation
tabulation1247813tabulation
ululation938093_ululation
undulation1147103undulation
vacuolation1644403vacuolation
vesiculation1746113vesiculation

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 Filter1786911406030.403443402.0
2DLD Change Limit1406031067.03319991.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.