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

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

90 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
spongily144490(None) 
podgily1435212_podgily
slangily1235382slangily
soggily1235952s_oggily
spangly1336472spang_ly
spongier1135742spongier
spongin1036372spongi_n
sponging1238822sponging
spongins1136562spongins
spongy1236742spong__y
spookily1744172spookily
spoonily1335232spoonily
sportily1337732sportily
spottily1335152spottily
springily1545582springily
spunkily1733772spunkily
stingily1236792stingily
stodgily1343902stodgily
stonily1049432ston_ily
bonnily1236873_bonnily
cloggily1543243cloggily
dingily1238103_dingily
foggily1535053_foggily
groggily1443283groggily
logily1039833_lo_gily
longly10279603_long_ly
loonily1037073loon_ily
mangily1339753_mangily
moonily1248943moon_ily
nonoily1049543_nonoily
phonily1537103phon_ily
pockily1846233_pockily
pokily15309063_po_kily
pongid104111583_pongi_d
pongids11347413_pongids
ponging113416153_ponging
pontil8315463_pontil_
pontils9312213_pontils
pudgily1434903_pudgily
punily11311773_pun_ily
saponify1644183sapon_ify
scantily1337583scantily
shaggily1643773shaggily
shingly143210813shing_ly
shinily13268933shin_ily
shoddily1643573shoddily
showily1636223sho_wily
singly104015853s_ing_ly
slinkily1534853slinkily
sloppily1544613sloppily
smokily1635373smo_kily
smudgily1543123smudgily
snobbily1544233snobbily
snoopily1345553snoopily
snootily1136253snootily
snottily1145553snottily
snowily1336883sno_wily
soapily1237963s_oapily
sonly85718053s_on__ly
sootily101810523s_ootily
sorrily1039833s_orrily
spangle1038403spang_le
sparkily1735023sparkily
speedily1465183speedily
spicily1438653sp_icily
spiffily19153483spiffily
spikily1635873sp_ikily
spinally1338023spinally
spindly13257383spin_dly
spoil75818653spo__il_
spoils84614533spo__ils
spoilt85016593spo__ilt
sponge939663spong__e
sponged1137953spong_ed
sponger1038523spong_er
spongers1137603spongers
sponges10311043spong_es
spongiest1237093spongiest
sponsal946343sponsal_
sponsion1045623sponsion
spoonbill13112473spoonbill
stagily1139053s_tagily
stockily1735443stockily
stonefly1443473stonefly
stormily1345243stormily
stringily1346003stringily
strongly1245953strong_ly
sunnily1037833s_unnily
swankily1833833swankily
wrongly1434553wrong_ly

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.440406115.9
2DLD Change Limit146162906.53022383.2
3Display Results90900.0303000.0
 (SQL Overall)178691907.00025527.3
 
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.