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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
fopping15351113(None) 
bopping143512031bopping
copping143918591copping
flopping16388771flopping
hopping154115271hopping
lopping123815221lopping
mopping143411471mopping
popping113715411popping
sopping123917201sopping
topping123514621topping
capping143819672capping
chopping183710262chopping
clopping153511082clopping
comping143518592comping
cooping123918932cooping
coping113927662co_ping
copying153411982copying
couping124317022couping
cropping153210882cropping
cupping144312382cupping
dapping133714792dapping
dipping134014832dipping
doping103919462do_ping
dropping14309282dropping
dupping133711042dupping
flapping16298152flapping
flipping16307662flipping
foaling113515842foaling
foaming133612992foaming
fobbing153410272fobbing
fogging133513732fogging
foiling113317652foiling
foining113013452foining
folding123912442folding
fonding123815422fonding
fooling113117372fooling
footing115017592footing
foppish1735102foppish
forcing134013752forcing
fording123717042fording
forging124114722forging
forking154014842forking
forming133615732forming
fouling113315372fouling
fowling143713112fowling
foxing175012432fo_xing
frapping16348102frapping
gapping134214782gapping
gipping133813122gipping
glopping14307752glopping
gypping16305842gypping
happing153817232happing
hipping153915102hipping
hooping133615702hooping
hoping123719742ho_ping
hoppings16306522hoppings
hoppling16206762hoppling
kepping16268592kepping
kipping163311872kipping
lapping124117022lapping
lipping123016072lipping
looping103615282looping
loping93921412lo_ping
louping104313982louping
mapping143413992mapping
moping114017102mo_ping
napping123514182napping
nipping123412872nipping
oping86322412_o_ping
opting94514402_opting
pepping113511622pepping
pipping113414742pipping
plopping12318702plopping
pooping123615442pooping
poppling12227322poppling
propping122811672propping
pupping114412502pupping
rapping123619102rapping
repping123314982repping
ripping123315742ripping
romping123113032romping
roping94023022ro_ping
rouping103715792rouping
sapping123519312sapping
shopping163611292shopping
sipping123117432sipping
slopping133811422slopping
soaping103616222soaping
souping104215532souping
stopping133611412stopping
supping123814532supping
swopping16377962swopping
tapping123317132tapping
tipping122814972tipping
toping94122992to_ping
toppings13286422toppings
toppling13197352toppling
tupping123411662tupping
upping114013702_upping
wapping153514602wapping
whopping19357372whopping
yapping153412612yapping
yipping152710682yipping
zapping213211472zapping
zipping212910572zipping

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit1076711053.17333933.5
3Display Results1051050.0462282.6
 (SQL Overall)1786911053.57949927.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.