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

127 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
sirupier103430(None) 
syrupier1343051syrupier
siruped1036012sirup_ed
sirupiest1154752sirupiest
siruping1136502siruping
soupier93111752s_oupier
sprucier1254792sprucier
stripier1058862stripier
abrupter1243793abrupter
airier64619363air__ier
chirpier15276303chir_pier
crepier1139743_crepier
crimpier14287323crimpier
crispier12297253crispier
croupier1246883croupier
crupper13338563_crupper
dippier123111393di_ppier
dirtier83312093dir_tier
disrupter1244723disrupter
drippier1385043drippier
firrier103410133fir_rier
frumpier1534173_frumpier
gimpier12247943gi_mpier
girlier8289523gir_lier
grapier103712603_grapier
gripier103210323_gripier
grippier1355203grippier
grumpier1334803_grumpier
hippier143212103hi_ppier
lippier112710573li_ppier
mirier83918363mir__ier
mirkier13319053mir_kier
nippier11319833ni_ppier
occupier1442963occupier
pipier104913983pi__pier
rapier84019993__rapier
ropier84118803__ropier
roupier9319493_roupier
rubier84814743__rubier
rulier65016353__rulier
sappier113613113s_appier
sarkier113413313sar_kier
saucier9810283s_aucier
scauper11379453scaup_er
scraper114513423scrap_er
scrapie115010943scrapie_
scrapies124612473scrapies
scrapper1466973scrapper
scrappier1544423scrappier
screwier1346433screwier
scrimpier1554243scrimpier
scripter12137783scripter
scrubber1434123scrubber
scrubbier1543333scrubbier
scruffier1743303scruffier
scruple1137193scruple_
scrupled1335823scrupled
scruples1237433scruples
scupper1367423s_cupper
scurfier13267053scurfier
scurvier13255883scurvier
seepier92912013s_eepier
shirtier1137943shir_tier
shrimpier1643063shrimpier
shrubbier1642193shrubbier
sicklier1457213sicklier
silkier114411643si_lkier
sillier74017593si_llier
siltier73413863si_ltier
simper103616293si_mp_er
simpler112910863si_mpler
sinopie948783sinopie_
sipper103920993si__pper
sirup74014913sirup___
sirups83710533sirup__s
sirupy11377053sirup__y
sissier73711363si_ssier
sizier1514813393si__zier
skimpier1634293skimpier
sleepier1036783sleepier
slippier1256533slippier
sloppier1255703sloppier
smirkier1444433smir_kier
snappier1266213snappier
snippier1255793snippier
snoopier10177273snoopier
snoutier8206973snoutier
soapier93411713s_oapier
soppier112711583s_oppier
sorrier72313733sor_rier
spier75728033s___pier
spirier93214073spir__ier
sprier84119063spr__ier
sprucer11317683spru_cer
spumier1137903s_pumier
spurrier10297693spurrier
strapper1258093strapper
strappier1345133strappier
strawier1137493strawier
striper94514793strip_er
stripper1247123stripper
stropper1247763stropper
stroppier1364453stroppier
strummer1234783strummer
strutter846503strutter
studier82510053s_tudier
stumpier1255883stumpier
stupider1133913s_tupider
sturdier9216963sturdier
super74924483s__up_er
supper104115433s__upper
surfier102613543sur_fier
surlier72915443sur_lier
swampier1544593swampier
sweepier1355493sweepier
swirlier1135213swir_lier
swoopier13175143swoopier
syruped1334543syrup_ed
syrupiest1453223syrupiest
syruping1434253syruping
tippier113210543ti_ppier
trippier1246623trippier
unrulier845333unrulier
wimpier14248053wi_mpier
wirier94215553wir__ier
wispier12249403wi_spier
zippier20308193zi_ppier

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.436409841.7
2DLD Change Limit1461621276.87321266.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.35524295.2
 
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.