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

128 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
devotion125676(None) 
demotion1169071demotion
devotions1356591devotions
decoction1447522decoction
delation92318082delation
deletion92011972deletion
demotions1258442demotions
deviation13312392deviation
devolution1486282devolution
devonian1244812devonian
devoting1338822devoting
devotional1444672devotional
emotion9711302_emotion
remotion10410232remotion
ademption1443493ademption
advection1545553advection
aeration8319933aeration
amotion9710473_amotion
bevatron1343883bevatron
dealation10313003dealation
deception1448323deception
decision1148523decision
decoctions1547143decoctions
decoration13314423decoration
decurion1146623decurion
deduction1377083deduction
defection151610643defection
deflation13310653deflation
dejection19178663dejection
delations102616593delations
deletions102610933deletions
delusion937433delusion
demeton1037683demet_on
demolition1376983demolition
demonian1147713demonian
demotic12412343demoti_c
demotics1338753demotics
demoting12311423demoting
demotist11311843demotist
denotation11311083denotation
denoting10311753denoting
denotive1238673denotive
dentation10315243dentation
dentin73919573de_nti_n
dentition1049633dentition
depiction1437273depiction
depletion1256663depletion
deposition13107833deposition
derision939073derision
derivation14712783derivation
derogation12410393derogation
desertion10410203desertion
desolation11311403desolation
desorption1346223desorption
detection121310413detection
detention10169543detention
detonation11310943detonation
detrition1049133detrition
devein1039143dev_ei_n
deviations14311163deviations
devoice13347343devo_ice
devoid1189363devo_i_d
devoir1076033devo_i_r
devoirs1175783devo_irs
devolutions15106263devolutions
devon95113683dev___on
devote104513783devot__e
devoted124111093devot_ed
devotee113811823devot_ee
devotees12286283devotees
devotes113713753devot_es
devotionals1552993devotionals
diction102313053d_iction
dilation92215463dilation
dilution9239143dilution
division1266683division
donation91513783donation
dotation91412733dotation
duration9312693duration
edition8310853_edition
eduction1169053eduction
elation73620453_elation
elevation1239233elevation
elution72913823_elution
emoticon1273793_emoticon
emotions10610283_emotions
enation73419233_enation
erosion7311113_erosion
evasion1036753_evasion
evection131910833_evection
eviction13228683_eviction
evocation142010293_evocation
evolution12117093_evolution
fetation11613143fetation
gelation93014433gelation
ideation9310493ide_ation
kenotron1244463kenotron
lavation1139973lavation
lection92614863le_ction
legation92412933legation
lenition8310083lenition
lotion65716523__lotion
mention9314373me_ntion
mesotron1045383mesotron
motion85217553__motion
negation92913023negation
nervation12610243nervation
notion64516583__notion
novation111710013novation
ovation101510023_ovation
peloton938743pelot_on
petition10711753petition
potion84519573__potion
prenotion1149173prenotion
reaction10612603reaction
relation82619773relation
remotions1149703remotions
retortion949673retortion
revision1138713revision
revocation15410813revocation
revolution13117563revolution
revoting12312033revoting
section92515663se_ction
sedation9312453sedation
sedition939333sedition
tevatron1143973tevatron
venation11513503venation
vexation1838783vexation

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621287.25320151.9
3Display Results1281280.0432976.7
 (SQL Overall)1786911287.44923988.6
 
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.