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

87 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
spriggier134384(None) 
sprigger12366501sprigg_er
springier1236021springier
piggier113510002_p_iggier
scraggier1344132scraggier
scroggier1343132scroggier
sprigged13316222sprigg_ed
spriggers13325492sprigg_ers
spriggiest14174532spriggiest
sprigging1435892sprigging
springer113311752spring_er
stringier1036712stringier
braggier12136453_braggier
craggier12116063_craggier
draggier11135773_draggier
dreggier1193553_dreggier
druggier11134833_druggier
fringier1236553_fringier
froggier1354643_froggier
groggier1134343_groggier
jiggier16377823__jiggier
piggie103210773_p_iggie_
piggies113813483_p_iggies
pricier113313113_pri_cier
prickier16368143_prickier
prigged12398933_prigg_ed
priggery1543993_prigg_ery
prigging13299093_prigging
priggish1544683_priggish
priggism1444383_priggism
prissier10157873_prissier
privier122910453_pri_vier
progger11319373_progg_er
puggier11309383_p_uggier
ridgier937883__ridgier
rigger85616713__rigg_er
saggier92912063s__aggier
scragglier1442283scragglier
scrimpier1554243scrimpier
shaggier13116053s_haggier
shriekier1652963shriekier
shrimpier1643063shrimpier
slaggier10126953s_laggier
smoggier1243973s_moggier
snaggier10136303s_naggier
snigger9328373s_nigg_er
sniggler10396113s_niggler
soggier93410883s__oggier
spanglier1244193spanglier
spicier115112463sp_i_cier
spiffier16255883sp_iffier
spikier13369983sp_i_kier
spinier93715163sp_i_nier
spirier93214073sp_i_rier
splurgier1252343splurgier
spongier1135743sp_ongier
sprawlier1443293sprawlier
sprier84119063spr___ier
spriggy14374213sprigg__y
sprightlier1751883sprightlier
springe103913983spring_e_
springed123911323spring_ed
springers12309983spring_ers
springes114014033spring_es
springiest13156673springiest
springily1545583springily
springing1338743springing
springlet1257523springlet
sprinkler1543573sprinkler
sprinter103810813spri_nter
spritzer1944563spri_tzer
sprucier1254793spr_ucier
squigglier2141593squigglier
staggier10167513s_taggier
stingier9279123s_tingier
straggler11377293straggler
stragglier1243503stragglier
stringer93812943string_er
stripier1058863stri_pier
struggler11264553struggler
swigger12338453s_wigg_er
swingier12267003s_wingier
trigger9329163_trigg_er
twiggier1333073_twiggier
wiggier12418863__wiggier
wriggler13295263_wriggler
wrigglier1462413_wrigglier

Search took 9 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 Limit148641877.71619264.0
3Display Results87870.0332636.4
 (SQL Overall)178691878.17221866.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.