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 “outsparkling” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
outsparkling195165(None) 
outbarking1746213out_bark_ing
outsailing1137563outs_a_iling
outsmarting1444383outsmar_ting
outsoaring1137703outsoar__ing
outspanning1443563outspa_nning
outsparkle1691853outsparkl__e
outsparkled1891593outsparkl_ed
outsparkles1791483outsparkl_es
outspeaking1844173outspeak_ing
outspelling1444143outsp_elling
outspring1238903outsp_r__ing
outstaring1137803outstar__ing
outstarting1245013outstar_ting
sparkling16226353___sparkling
outarguing1244534out__arguing
outasking1437314out__ask_ing
outbaking1638234out_ba_k_ing
outbawling1644934out_ba_wling
outbrawling1743704outbra_wling
outcaviling1742984out_caviling
outcharging1843784outchar_ging
outcharming1943584outchar_ming
outcrawling1743654outcra_wling
outdaring1179724out_dar__ing
outdazzling2141734out_dazzling
outearning1146744out_ear_ning
outfabling1644544out_fa_bling
outflanking1943414outflank_ing
outgambling1742134out_gambling
outglaring1246274outglar__ing
outhandling1643464out_handling
outhearing1438444outhear__ing
outlearning1243544outlear_ning
outmarching1943604out_marching
outpacing1478364out_pa__cing
outpainting1445154out_painting
outpassing1355854out_pa_ssing
outpeopling1653174out_peopling
outpolling1346214out_p_olling
outpraying1646524out_p_raying
outpricing1547004out_p_ricing
outpulling1344824out_p_ulling
outpursuing1442284out_pursuing
outranking1537674out_rank_ing
outroaring1138834outroar__ing
outsavoring1542964outs_avoring
outsaying1338704outs_a__ying
outscoring1346234outscor__ing
outscorning1443474outscor_ning
outselling1188024outs__elling
outserving1446744outs_er_ving
outshaming1645664outsha__ming
outskating1536854outska__ting
outslicking1843734outslick_ing
outsmelling1453564outs_melling
outsmiling1345744outs__miling
outsmoking1745124outs_mok_ing
outsnoring1145614outsnor__ing
outsourcing1452974outsour_cing
outspeeding1543474outsp_eeding
outspending1544314outsp_ending
outsprang1243904outsp_r__ang
outspreading1652714outspreading
outspringing1652414outspringing
outsprings1343954outsp_r__ings
outsprint1148204outsp_r__int
outsprinting1553034outsprinting
outsprung1243154outsp_r__ung
outstanding1344554outsta_nding
outstating1139364outsta__ting
outstaying1446094outsta__ying
outstriding1344204outs_triding
outstriving1543794outs_triving
outsulking1544724outs_ulk_ing
outswearing1544074outswear__ing
outtalking1545484out_talk_ing
outtasking1545724out_task_ing
outthanking1943434outthank_ing
outtraveling1652034outtraveling
outwalking1845284out_walk_ing
outwarring1445364out_war_ring
outwearing1437184outwear__ing
outwearying1843204outwear_ying
outwhirling1842464outwhir_ling
outworking1845494out_work_ing
spackling18266504___spackling
sparking152812544___spark_ing
sparling112714534___spar_ling
unshackling2141654_unshackling
unsnarling1143914_unsnar_ling
unsparing1237714_unspar__ing
unstartling1242384_unstartling

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790936.84318236.2
3Display Results93930.0462021.7
 (SQL Overall)178691937.03225411.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.