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

255 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
deviating1431108(None) 
aviating12311012_aviating
debating123213732de_bating
debiting122511202debi_ting
decimating1648752decimating
dedicating1539142dedicating
defeating142311972defeating
deflating142610712deflating
delating103119602de_lating
delisting112710502delisting
demitting13239072demitting
depicting1537812depicting
depilating1439182depilating
derating103222282de_rating
desisting112810382desisting
devesting14249902devesting
deviation13312392deviation
deviations14311162deviations
deviative1647722deviative
deviling1311812852devi_ling
devilling1436702devilling
devising133111522devi_sing
devoting1338822dev_oting
evicting1437482_evicting
eviting11511372_evi_ting
levigating1545692levigating
levitating1446652levitating
mediating13311202mediating
obviating1545052obviating
seriating10916402seriating
undeviating1644722undeviating
aerating92821003ae_rating
alleviating1553593alleviating
beating104326873be__ating
befitting15236623befitting
bemisting1438073bemisting
berating113220763be_rating
bloviating1643813bloviating
caveating1539293caveating
cavitating1646903cavitating
dating85326483d___ating
deaerating12311563deaerating
deairing10311893deai_ring
dealing94323233de__aling
deaminating1547973deaminating
deaning94020473de__aning
deaving123814753de__aving
debasing12238063de_basing
debeaking1735923debeaking
debuting12268633de_buting
decanting132510633decanting
decaying15239453de_caying
deceasing1338403deceasing
deciding132210833deci_ding
declaring1339573declaring
declawing1636213declawing
decocting1538123decocting
decorating14312073decorating
deducting1436843deducting
deejaying2142753deejaying
defacing15238683de_facing
defaming15238463de_faming
defatting1436103defatting
defecating17237783defecating
defecting162510223defecting
defilading1643643defilading
defiling132812463defi_ling
defining133711803defi_ning
defoaming1645653defoaming
defoliating1645823defoliating
defraying1735853defraying
deglazing2135133deglazing
degrading13137373degrading
degusting1236163degusting
dehiscing1643733dehiscing
dehorting1447213dehorting
deicing11312193de_i_cing
deifying1637633de_ifying
deigning1137753de_igning
dejecting20217793dejecting
delaying133210973de_laying
deleading1237773deleading
deleaving1436263deleaving
delegating1337673delegating
deleting103314423de_leting
delighting1644993delighting
deliming12310373deli_ming
delimiting1445843delimiting
delineating1346373delineating
demasting1338453demasting
demeaning1337243demeaning
dementing13311043dementing
demising122012523demi_sing
demoting12311423de_moting
denigrating14146923denigrating
denitrating13128333denitrating
denoting10311753de_noting
denting94422183de__nting
denudating1345263denudating
depainting14156153depainting
departing1349513departing
deplaning1338053deplaning
depleting1378193depleting
deporting1369593deporting
depraving1635973depraving
depurating1438643depurating
deputing12238793de_puting
derailing112011313derailing
deratting1139513deratting
deriding112512933deri_ding
deriving132510743deri_ving
derogating1348633derogating
desalting1138843desalting
descanting1446923descanting
deserting11713143deserting
desiccating1744703desiccating
designating1446073designating
designing1236623designing
desiring10312143desi_ring
desolating1239463desolating
despiting13179323despiting
detailing112510413detailing
detaining112510473detaining
detecting13259983detecting
detesting112610323detesting
deticking1736043deticking
detonating1248823detonating
detracting1438713detracting
devaluating1645053devaluating
devaluing1434833devaluing
devastating1644703devastating
deveining1436393deveining
develing133212733dev_eling
deviant11311313devia__nt
deviate11312713deviat__e
deviated13311043deviat_ed
deviates12312733deviat_es
deviator1248313deviat_or
deviators1358533deviators
deviatory1666443deviatory
devilkin1642953devilkin_
devilkins1742803devilkins
devoicing16145223devoicing
devolving1733983devolving
devouring1435953devouring
dewaxing20215293de_waxing
dezincing2244183dezincing
dialing94318173d__ialing
dictating1338883dictating
dieting93616833d__ieting
dilating102714903d_ilating
dinting93520553d__inting
disrating11714553disrating
divagating1644003divagating
diverting142410333diverting
divesting14298483divesting
dividing1437183divi_ding
divining1338413divi_ning
doating93816863d__oating
dominating1449403dominating
donating10311803d_onating
drifting13338733d_rifting
eating75134403_e__ating
editing9313133_edi_ting
educating1337933educating
elating83423083_e_lating
elevating1338203elev_ating
eluviating1444893eluviating
emitting112410353_emitting
epilating12310963_epilating
equating18310113_equating
estating92614993_estating
evading1237283_ev_ading
everting122213133_everting
evincing1446183_evincing
existing1639073_existing
exiting15311393_exi_ting
expiating1938543expiating
exuviating2144523exuviating
feinting123410833fe_inting
fellating1339243fellating
filiating1339243filiating
foliating1339253foliating
gelating103015733ge_lating
geminating1447753geminating
gemmating1576443gemmating
gestating11229983gestating
heating114024323he__ating
heisting123411043he_isting
herniating1445983herniating
hesitating1448003hesitating
ideating10311703ide__ating
inviting1239733invi_ting
lariating10311783lariating
legating102313113le_gating
leniting9312353leni_ting
levanting1345523levanting
medicating1648943medicating
meditating1448123meditating
meriting11314683meri_ting
navigating1544993navigating
negating102012833ne_gating
opiating11410093_opiating
radiating111112123radiating
rebaiting12311643rebaiting
rebating112418343re_bating
reciting113118073reci_ting
recoating121317463recoating
recrating121318793recrating
redating102620173re_dating
redialing11311843redialing
refitting132811123refitting
reflating132514713reflating
regrating111316213regrating
reheating132314913reheating
relating92725443re_lating
relisting102414353relisting
remating112322413re_mating
reminting122315103reminting
remitting122412623remitting
repeating122618983repeating
replating122217393replating
reseating102421533reseating
resifting133512093resifting
resinating11313733resinating
resisting103215313resisting
resiting93521123resi_ting
resitting103414873resitting
reslating102516993reslating
restating102319413restating
retinting102215253retinting
revealing132611883revealing
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
revibrating1745573revibrating
reviewing1635513reviewing
reviling122917213revi_ling
reviolating1556243reviolating
revising122714403revi_sing
revisiting1446953revisiting
reviving152910503revi_ving
revolting1339633revolting
revoting12312033rev_oting
satiating10311803satiating
seating84130683se__ating
sedating103014113se_dating
sensating1039253sensating
serrating10513203serrating
speciating1548123speciating
striating10914193striating
variating13310943variating
vesicating1646893vesicating
vialing113614163__vialing
vitiating1338403vitiating

Search took 7 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.203880251.2
2DLD Change Limit1486412556.22023897.3
3Display Results2552550.1062405.7
 (SQL Overall)1786912556.52927368.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.