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

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

52 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
plopping1231870(None) 
clopping153511081clopping
flopping16388771flopping
glopping14307751glopping
lopping123815221_lopping
popping113715411p_opping
propping122811671propping
slopping133811421slopping
blipping15306802blipping
blooping13248842blooping
bopping143512032_bopping
chopping183710262chopping
clapping153810602clapping
clipping15349152clipping
clomping15329652clomping
copping143918592_copping
cropping153210882cropping
dropping14309282dropping
eloping103512832elo_ping
flapping16298152flapping
flipping16307662flipping
fopping153511132_fopping
hopping154115272_hopping
lapping124117022_lapping
lipping123016072_lipping
looping103615282_looping
loping93921412_lo_ping
louping104313982_louping
mopping143411472_mopping
peopling1338352peopling
pepping113511622p_epping
pipping113414742p_ipping
plodding13166342plodding
plonking15358562plonking
plotting113011012plotting
plotzing20276142plotzing
plowing133111722plo_wing
ploying132811572plo_ying
plumping15277632plumping
pooping123615442p_ooping
poppling12227322p_oppling
prepping12309762prepping
pupping114412502p_upping
shopping163611282shopping
slapping133510832slapping
slipping133510662slipping
sloping104114072slo_ping
sopping123917202_sopping
stopping133611412stopping
swopping16377962swopping
topping123514622_topping
whopping19357372whopping

Search took 5 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 Filter1786911210590.296603685.8
2DLD Change Limit121059524.17329010.1
3Display Results52520.0331575.8
 (SQL Overall)178691524.50239691.5
 
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.