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

130 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
plosives133589(None) 
plosive1236671plosive_
explosives2243642explosives
implosives1743052implosives
passives13228822passives
plosions1038022plosions
posies84431432p_osi_es
alewives1444283alewives
alsikes1137263al_sikes
amosites10311233amosites
closes85425593clos__es
closings11277673closings
closures10228953closures
cloves114918823clo__ves
cosies84932153_cosi_es
cosines94122673_cosines
cursives1337103cursives
elatives1139783elatives
elusive1057003elusive_
enosises8311003enosises
eosines73718293_eosines
erosive1039193erosive_
explosive2144833explosive_
floosies113210233floosi_es
flosses103411973flos_ses
flossies112810123flossies
glaives11347833gl_aives
glories81915923glori_es
glosses84014123glos_ses
glossies93311253glossies
gloves104115183glo__ves
implosive1643953implosive_
inosines8312703inosines
inosites8312793inosites
jussives1833843jussives
lives86133193_l__ives
loaves94813853_lo_aves
looies65025833_looi_es
lories64933043_lori_es
lorises73918593_lorises
loses56742013_los__es
losings82810623_losings
losses65925233_los_ses
louies64525103_loui_es
loves85332013_lo__ves
lowlives1434573_lowlives
lysines10369093_lysines
missives133212843missives
motives123611893_motives
ogives10367913__ogives
oldwives1542463oldwives
olives94313953__olives
ologies8615023ologi_es
opposites1346143opposites
palsies94420273palsi_es
pansies94521983pansi_es
passive12239593passive_
patsies93919483patsi_es
pensive122610393pensive_
peonies93620153peoni_es
pepsines1239883pepsines
phonies123717513phoni_es
pilosities1247803pilosities
piosities11311723piosities
plaices11411143pl_aices
plashes124417393plas_hes
platies93722543plati_es
plausive1344583plausive_
plies74526513pl__i_es
pliskies1475973pliskies
plisses94411773plis_ses
ploidies1138173ploidies
plosion939113plosi_on
plotlines1146823plotlines
plotties103111413plotties
plotzes18317703plo_tzes
plover115312613plo__ver
plovers123611833plo__vers
pluses83618073plus__es
plushes124313673plus_hes
plusses93510693plus_ses
podites103014733p_odites
poesies93217403poesi_es
pogies94123543p_ogi_es
poises84226543p_o_ises
pokies125921333p_oki_es
polices113118053p_olices
polies84034583p_oli_es
polishes13711783polishes
pollices12410753pollices
ponies84833463p_oni_es
poolsides1254553poolsides
pooves113914713p_o_oves
popsies112816463popsi_es
poses74642763p_os__es
posited10511493p_osited
positives1459173p_ositives
posits85718713p_osi_ts
posoles9314883p_osoles
posses85128803p_os_ses
posties93128813p_osties
potsies93019483potsi_es
prelives13310383prelives
presides11414913presides
profiles133211233profiles
prolines102619693prolines
promines123018803promines
promises122916763promises
propines122618933propines
proses84733473pros__es
prosier93817483prosi_er
prosiest10416523prosi_est
prosiness11311683prosiness
prosses94019513pros_ses
prossies101515223prossies
prosties101421193prosties
proves114322253pro__ves
provides1439883provides
proxies163014933proxi_es
ptoses83514673ptos__es
ptosis83611823ptosi__s
pussies93615693pussi_es
pyoses114314303pyos__es
pyosis114012123pyosi__s
pyrosises1457583pyrosises
sloshes103811803slos_hes
sploshes1336133splos_hes
votives13337953_votives
whosises1435333whosises
zloties1639913zloti_es

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.423422437.4
2DLD Change Limit1461621307.23320207.7
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.70223200.6
 
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.