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 “predation” 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
predation1231346(None) 
predations13812151predations
creation102816512cre_ation
cremation13511642cremation
crenation11412922crenation
depredation1546922depredation
gradation11107712gradation
perdition1249012perdition
precaution1447242precaution
predating13514652predating
predatism1447292predatism
predator11310062predat_or
predication16412432predication
prediction15410302prediction
prenotion1149172prenotion
preoption1348082preoption
privation14311172privation
probation13412182probation
pronation11415702pronation
proration11415982proration
redaction1259662_redaction
relation82619772_relation
sedation9312452_sedation
aeration8319933_aeration
arcuation11410583arcuation
caudation1269993caudation
chelation1439973chelation
creatin93618133cre_ati_n
creations112614543cre_ations
cremations14410713cremations
crenations12511693crenations
delation92318083_delation
deprecation1648963deprecation
depredations1646733depredations
edition8310853__edition
elation73620453__elation
elevation1239233elevation
emendation1346553emendation
enation73419233__enation
erection102115513ere_ction
erudition1046173erudition
exudation1787693exudation
fetation11613143_fetation
gelation93014433_gelation
gradations1286863gradations
graduation1285793graduation
ideation9310493ide_ation
imprecation1746543imprecation
iodation9310383_iodation
iteration9515033iteration
laudation1088133laudation
legation92412933_legation
mediation12312293_mediation
negation92913023_negation
nervation12610243nervation
nidation9410583_nidation
operation11314003operation
oration71617713or__ation
oxidation1746323oxidation
palmation13310223palmation
palpation1339073palpation
peltation11312963peltation
perditions1348873perditions
perennation1348083perennation
permeation14410563permeation
peroration12316003peroration
pervasion1446073pervasion
petition10711753p_etition
phonation1439393phonation
pinnation1138013pinnation
placation1339773placation
planation11310123planation
plication13311683plication
potation101716783p_otation
precative16312573precative
precautions1546553precautions
precision13410053precision
predacious1544773predacious
predacity1745603predacity
predate10616893predat__e
predated12513273predat_ed
predates11615823predat_es
predatisms1545253predatisms
predators12310093predators
predatory1547713predatory
predawn1335353preda__wn
predications17411183predications
predictions1649653predictions
preemption16105253preemption
prefixion2144113prefixion
prelatic12311293prelati_c
prelatism1347863prelatism
prelection141511293prelection
prelibation15128663prelibation
prelusion1156603prelusion
prenotions1248293prenotions
preoptions1447643preoptions
preparation1549273preparation
preportion1448873preportion
preradio1145723preradio_
preunion1046893pre_union
prevention1549173prevention
prevision1448013prevision
privations15310103privations
proaction13410103proaction
probations14311083probations
production1547893production
promotion1359503promotion
pronations12314033pronations
prorations12314463prorations
pulsation1137143pulsation
pupation1269503p_upation
purgation1247393purgation
radiation10313403_radiation
ration64226013_r__ation
reaction10612603_reaction
recaution1148093_recaution
redactions1359133_redactions
redating102620173_redating
reduction1259903_reduction
reedition1047833reedition
reflation12412333_reflation
relations92418333_relations
remotion10410233_remotion
rendition1058933_rendition
restation9316913_restation
rogation91612053_rogation
rotation81615453_rotation
sedations10311253_sedations
sedition939333_sedition
seriation9318063seriation
serration9414073serration
sudation9310803_sudation
tradition1047593tradition
trepidation1445493trepidation
urination9312173urination
venation11513503_venation
vernation12311083vernation
vexation1838783_vexation

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 Limit1486411396.65622331.9
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.13925030.3
 
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.