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

176 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
deviations1431116(None) 
deviation13312391deviation_
aviations12311552_aviations
dealations11311372dealations
decimations16410162decimations
dedications15310872dedications
deflations1439712deflations
delations102616592de_lations
dentations11413632dentations
depictions1546892depictions
depilations14310902depilations
derivations15611492derivations
deviating14311082deviati_ng
deviationism1854022deviationism
deviationist1656152deviationist
deviators1358532deviat_ors
devotions1356592dev_otions
divinations15128412divinations
evictions14228622_evictions
levigations1546212levigations
levitations1448292levitations
mediations13310982mediations
obviations1545462obviations
seriations10316682seriations
aerations9317903ae_rations
alleviations1554493alleviations
aviation11312743_aviation_
bevatrons1443713bev_atrons
bloviations1643753bloviations
cavitations1647843cavitations
cessations1256473cessations
ciliations121111003ciliations
damnations1337083damnations
darnations1138413darnations
deaerations12311673deaerations
dealation10313003dealation_
deaminations151010133deaminations
deceptions1547863deceptions
decillions1345433decillions
decimation15411623decimation_
decisions1248383deci_sions
declinations15410223declinations
decoctions1547143decoctions
decorations14312883decorations
dedication14311963dedication_
deductions1467133deductions
defamations1745893defamations
defecations1779003defecations
defections161510203defections
definitions1545603definitions
deflation13310653deflation_
defoliations1647593defoliations
deifications18410653deifications
dejections20168353dejections
delation92318083de_lation_
delegations1348033delegations
deletions102610933de_letions
delineations1346763delineations
demissions1345663demissions
demotions1258443de_motions
denegations1348543denegations
denigrations1447353denigrations
denotations1239853denotations
dentation10315243dentation_
dentitions1148853dentitions
denudations1346343denudations
deoxidations2145243deoxidations
depiction1437273depiction_
depilation13312033depilation_
depletions1355743depletions
deprivations1897923deprivations
deputations1448343deputations
derisions1038843deri_sions
derivation14712783derivation_
derogations1349393derogations
desertions1139883desertions
desiccations1755653desiccations
designations1456943designations
desolations12310593desolations
destinations13412663destinations
detections131410043detections
detentions11148803detentions
detonations1239373detonations
detractions14118273detractions
detritions1148953detritions
devaluations1646353devaluations
devastations1645823devastations
deviates12312733deviat__es
deviationisms1953883deviationisms
deviationists17104743deviationists
deviative1647723deviati_ve
deviator1248313deviat_o_r
deviatory1666443deviat_ory
devilkins1742803devilki_ns
devolutions15106263devolutions
devotion1256763dev_otion_
diatrons939613d__iatrons
dictations1389703dictations
dictions111812673d__ictions
dilations102614453d_ilations
divagations16103833divagations
divination14139233divination_
divisions1396283divi_sions
dominations14611043dominations
donations101112353d_onations
dotations101411633d_otations
dubitations1456673dubitations
durations10311463d_urations
editions9310403_edi_tions
educations1339233educations
elations83719123_e_lations
elevations1338633elev_ations
eluviations14115793eluviations
enations83316903_e_nations
epilations12311713_epilations
equations1839493_equations
evasions1136543_ev_asions
evections142510693_evections
eviction13228683_eviction_
evocations15259873_evocations
expiations1959663expiations
exuviations2195693exuviations
fellations1338063fellations
fetations12511383fe_tations
filiations13119093filiations
foliations1399943foliations
gelations102513093ge_lations
geminations14139253geminations
gemmations1545003gemmations
gestations1139773gestations
herniations1447403herniations
hesitations1448543hesitations
ideations1039903ide__ations
invitations1449053invitations
lavations1238973lav_ations
legations102711923le_gations
lenitions939473leni_tions
leviathans1651373leviathans
levigation1447023levigation_
levitation1349443levitation_
mediation12312293mediation_
medications1649933medications
meditations1449333meditations
mentations12312583mentations
navigations1545203navigations
negations102811963ne_gations
nervations1359483nervations
novations12139003nov_ations
obviation1446093obviation_
ovations11149263_ov_ations
peltations12311553peltations
petitions11511083peti_tions
privations15310103privations
radiations11311923radiations
recitations13314203recitations
reflations13311233reflations
relations92418333re_lations
relictions12310023relictions
restations10315843restations
revelations14410303revelations
revisions1238593revi_sions
revocations16410313revocations
satiations10312113satiations
sedations10311253se_dations
seditions1039013sedi_tions
sensations1059853sensations
seriation9318063seriation_
serrations10313093serrations
speciations1548483speciations
striations10312793striations
tevatrons1244003tev_atrons
variations13310773variations
venations12311723ve_nations
vernations13310333vernations
vexations1937753ve_xations
vitiations1338743vitiations

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.436409841.7
2DLD Change Limit1406031766.62621219.9
3Display Results1761760.0762315.8
 (SQL Overall)1786911767.13825033.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.