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

166 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
diverting14241033(None) 
diverging15226691diverging
divesting14298481divesting
adverting1437222adverting
averting122512732_averting
deserting11713142deserting
devesting14249902devesting
dieting93616832di_e_ting
digesting12208672digesting
directing1338822directing
disserting121310852disserting
divorcing1644322divorcing
everting122213132_everting
inverting131013222inverting
livering122012382liver_ing
obverting1536302obverting
reverting132315132reverting
riveting12139442rive_ting
rivetting13256412rivetting
advecting1645113advecting
airting83616303ai__rting
alerting91312383_alerting
asserting1038663asserting
averring12239063_averring
bisecting1436973bisecting
caveating1539293caveating
caverning1536283caverning
cavorting1536063cavorting
converting16313133converting
covering142215723cover_ing
coveting141912303cove_ting
daikering1536103daiker_ing
darting94020663d__arting
davening13258873dave_ning
deaerating12311563deaerating
decerning1337293decerning
defeating142311973defeating
defecting162510223defecting
deferring1436143deferring
degerming1435753degerming
dehorting1447213dehorting
dejecting20217793dejecting
deleting103314423dele_ting
delivering1545173deliver_ing
dementing13311043dementing
demerging1436643demerging
demeriting1448683demeriting
denting94422183d__enting
departing1349513departing
deperming1537113deperming
deporting1369593deporting
derating103222283d__erating
deserving1497903deserving
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
deveining1436393deveining
develing133212733deve_ling
deviating14311083deviating
devoting1338823dev_oting
diapering1339033diaper_ing
dickering1737463dicker_ing
dictating1338883dictating
dieing84018653di_e__ing
differing1746483differ_ing
dighting142510843di_ghting
dilating102714913di_lating
diluting10248983di_luting
dimerizing2346773dimerizing
dinting93520553di__nting
dipnetting1453623dipnetting
dirking133812603di__rking
dirling93316073di__rling
dirtying1336093di__rtying
disarming1338803disarming
discepting1658473discepting
discerning1447863discerning
diseasing11310833diseasing
disheriting1646453disheriting
disjecting2177243disjecting
disparting1438933disparting
dispersing1449303dispersing
disporting1439823disporting
disputing1337763disputing
disrating11714553disrating
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserving15117013disserving
distorting1239593distorting
dithering1499853dither_ing
divagating1644003divagating
divergent1447363divergent
diversify1943463diversify
diversion1346453diversion
diversions1446533diversions
diversity1645223diversity
divert103922813divert___
diverted13199583divert_ed
diverter12238623divert_er
diverters13227873diverters
diverts114412033divert__s
dividing1437183div_iding
diving113717953div___ing
divining1338413div_ining
divulging15103273divulging
divulsing14103933divulsing
divvying1932773div_vying
dizening19177143dize_ning
dovening13238353dove_ning
dowering132510613dower_ing
driveling1445763drive_ling
drivelling1543983drivelling
dueting93814393d_ue_ting
duetting1047183d_uetting
duvetine1245163duve_tine
exerting162211153_exerting
experting1938053experting
exserting1736663exserting
fevering152510083fever_ing
fileting1239303file_ting
girting93113333gi__rting
governing1435533governing
havering152211053haver_ing
hovering151911143hover_ing
ideating10311703_ideating
inserting10914243inserting
inventing13109973inventing
inversing1389623inversing
invertin11910233invertin_
invertins12911023invertins
investing13119393investing
iterating10314253_iterating
levering122212503lever_ing
liberating1349253liberating
libertine1147433libertine
livening12248153live_ning
miseating121215433miseating
mitering113015403miter_ing
nidering10510483nider_ing
overing111918053_over_ing
perverting1646623perverting
piercing1346663pi_ercing
pipetting1435513pipetting
pivoting1436183piv_oting
quivering2235873quiver_ing
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
revesting132814123revesting
revetting132912633revetting
riverine11310803river_ine
severing122013853sever_ing
shivering1637333shiver_ing
silvering1337923silver_ing
slivering1338083sliver_ing
subverting1666293subverting
tiering8315253ti_er_ing
venting114218093__venting
verging123812303__verging
versing112314193__versing
vesting114618683__vesting
vetting114216563__vetting
viverrine1544673viverrine
wavering152410543waver_ing

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.406440125.6
2DLD Change Limit1486411667.17320722.3
3Display Results1661660.0762184.2
 (SQL Overall)1786911667.65523343.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.