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 “deviation” 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
deviation1331239(None) 
deviations14311161deviations
aviation11312742_aviation
dealation10313002dealation
decimation15411622decimation
dedication14311962dedication
deflation13310652deflation
delation92318082de_lation
dentation10315242dentation
depiction1437272depiction
depilation13312032depilation
derivation14712782derivation
deviating14311082deviating
deviative1647722deviative
deviator1248312deviat_or
devotion1256762dev_otion
divination14139232divination
eviction13228682_eviction
levigation1447022levigation
levitation1349442levitation
mediation12312292mediation
obviation1446092obviation
seriation9318062seriation
aeration8319933ae_ration
alleviation1454653alleviation
aviations12311553_aviations
bevatron1343883bev_atron
bloviation1544003bloviation
cavitation1549133cavitation
cessation1176853cessation
ciliation111112493ciliation
damnation1238403damnation
darnation1039823darnation
deaeration11313013deaeration
dealations11311373dealations
deamination14411543deamination
deception1448323deception
decillion1245833decillion
decimations16410163decimations
decision1148523deci_sion
declination14411873declination
decoction1447523decoction
decoration13314423decoration
dedications15310873dedications
deduction1377083deduction
defamation1646843defamation
defecation1679803defecation
defection151610643defection
definition1445963definition
deflations1439713deflations
defoliation1548313defoliation
deification17411663deification
dejection19178663dejection
delations102616593de_lations
delegation1238883delegation
deletion92011973de_letion
delineation1247763delineation
demission1246033demission
demotion1169073de_motion
denegation1249413denegation
denigration1348463denigration
denotation11311083denotation
dentations11413633dentations
dentition1049633dentition
denudation1247303denudation
deoxidation2045953deoxidation
depictions1546893depictions
depilations14310903depilations
depletion1256663depletion
deprivation1788773deprivation
deputation1339393deputation
derision939073deri_sion
derivations15611493derivations
derogation12410393derogation
desertion10410203desertion
desiccation1646383desiccation
designation1347483designation
desolation11311403desolation
destination12413843destination
detection121310413detection
detention10169543detention
detonation11310943detonation
detraction13138583detraction
detrition1049133detrition
devaluation1547073devaluation
devastation1546733devastation
deviate11312713deviat__e
deviated13311043deviat_ed
deviates12312733deviat_es
deviationism1854023deviationism
deviationist1656153deviationist
deviators1358533deviators
deviatory1666443deviatory
devilkin1642953devilki_n
devolution1486283devolution
devotions1356593dev_otions
diatron839283d__iatron
dictation12810563dictation
diction102313053d__iction
dilation92215463d_ilation
divagation15104373divagation
divinations15128413divinations
division1266683divi_sion
domination13712373domination
donation91513783d_onation
dotation91412733d_otation
dubitation1377333dubitation
duration9312693d_uration
edition8310853_edi_tion
education12310203education
elation73620453_e_lation
elevation1239233elev_ation
eluviation1376613eluviation
enation73419233_e_nation
epilation11312963_epilation
equation17310483_equation
evasion1036753_ev_asion
evection131910833_evection
evictions14228623_evictions
evocation142010293_evocation
expiation18710423expiation
exuviation20116343exuviation
fellation1238843fellation
fetation11613143fe_tation
filiation121110243filiation
foliation121110793foliation
gelation93014433ge_lation
gemination131410653gemination
gemmation1445963gemmation
gestation10310663gestation
herniation1348443herniation
hesitation1349633hesitation
ideation9310493ide__ation
invitation13410023invitation
lavation1139973lav_ation
legation92412933le_gation
lenition8310083leni_tion
leviathan1551673leviathan
levigations1546213levigations
levitations1448293levitations
mediations13310983mediations
medication15411173medication
meditation13410743meditation
mentation11313983mentation
navigation1446003navigation
negation92913023ne_gation
nervation12610243nervation
novation111710013nov_ation
obviations1545463obviations
ovation101510023_ov_ation
peltation11312963peltation
petition10711753peti_tion
privation14311173privation
radiation10313393radiation
recitation12315943recitation
reflation12412333reflation
relation82619773re_lation
reliction11310693reliction
restation9316913restation
revelation13410923revelation
revision1138713revi_sion
revocation15410813revocation
satiation9313433satiation
sedation9312453se_dation
sedition939333sedi_tion
sensation9510583sensation
seriations10316683seriations
serration9414063serration
speciation1449393speciation
striation9313483striation
tevatron1143973tev_atron
variation12312393variation
venation11513503ve_nation
vernation12311083vernation
vexation1838783ve_xation
vitiation1239563vitiation

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.1561145455.1
2DLD Change Limit1486411766.98321286.1
3Display Results1761760.0931892.5
 (SQL Overall)1786911767.23224708.4
 
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.