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

121 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
devotions135659(None) 
demotions1258441demotions
devotion1256761devotion_
decoctions1547142decoctions
delations102616592delations
deletions102610932deletions
demotion1169072demotion_
deviations14311162deviations
devolutions15106262devolutions
devoting1338822devoti_ng
devotional1444672devotional
devotionals1552992devotionals
emotions10610282_emotions
remotions1149702remotions
ademptions1543383ademptions
advections1645553advections
aerations9317903aerations
amotions1069843_amotions
bevatrons1443713bevatrons
dealations11311373dealations
deceptions1547863deceptions
decisions1248383decisions
decoction1447523decoction_
decorations14312883decorations
decurions1246023decurions
deductions1467133deductions
defections161510203defections
deflations1439713deflations
dejections20168353dejections
delation92318083delation_
deletion92011973deletion_
delusions1037053delusions
demetons1137623demet_ons
demolitions1446523demolitions
demotics1338753demoti_cs
demoting12311423demoti_ng
demotists1247323demotists
denotations1239853denotations
denoting10311753denoti_ng
dentations11413633dentations
dentins83419223de_nti_ns
dentitions1148853dentitions
depictions1546893depictions
depletions1355743depletions
depositions14117683depositions
derisions1038843derisions
derivations15611493derivations
derogations1349393derogations
desertions1139883desertions
desolations12310593desolations
desorptions1445993desorptions
detections131410043detections
detentions11148803detentions
detonations1239373detonations
detritions1148953detritions
deveins1138813dev_ei_ns
deviation13312393deviation_
devious1138523dev__ious
devoices14307413devo_ices
devoirs1175783devo_i_rs
devolution1486283devolution_
devonian1244813devonian_
devons104512253dev___ons
devotees12286283devot_ees
devotes113713753devot__es
dictions111812673d_ictions
dilations102614453dilations
dilutions10248583dilutions
divisions1396283divisions
donations101112353donations
dotations101411633dotations
durations10311463durations
editions9310403_editions
eductions1268773eductions
elations83719123_elations
elevations1338633elevations
elutions82513053_elutions
emoticons1353783_emoticons
emotion9711303_emotion_
enations83316903_enations
erosions8310343_erosions
evasions1136543_evasions
evections142510693_evections
evictions14228623_evictions
evocations15259873_evocations
evolutions13107043_evolutions
fetations12511383fetations
gelations102513093gelations
ideations1039903ide_ations
kenotrons1344523kenotrons
lavations1238973lavations
lections102413843le_ctions
legations102711923legations
lenitions939473lenitions
lotions74614763__lotions
mentions10312893me_ntions
mesotrons1145513mesotrons
motions94215003__motions
negations102811963negations
nervations1359483nervations
notions74014483__notions
novations12139003novations
ovations11149263_ovations
pelotons1038913pelot_ons
petitions11511083petitions
potions93417423__potions
prenotions1248293prenotions
reactions11711713reactions
relations92418333relations
remotion10410233remotion_
retortions1049143retortions
revisions1238593revisions
revocations16410313revocations
revolutions1497633revolutions
revoting12312033revoti_ng
sections102714703se_ctions
sedations10311253sedations
seditions1039013seditions
tevatrons1244003tevatrons
venations12311723venations
vexations1937753vexations

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 Limit1486411216.59322545.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.06225303.2
 
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.