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

126 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
topping12351462(None) 
bopping143512031bopping
copping143918591copping
fopping153511131fopping
hopping154115271hopping
lopping123815221lopping
mopping143411471mopping
popping113715411popping
sopping123917201sopping
stopping133611411stopping
tapping123317131tapping
tipping122814971tipping
toping94122991to_ping
toppings13286421toppings
toppling13197351toppling
tupping123411661tupping
capping143819672capping
chopping183710262chopping
clopping153511082clopping
comping143518592comping
cooping123918932cooping
coping113927662co_ping
copying153411982copying
couping124317022couping
cropping153210892cropping
cupping144312382cupping
dapping133714792dapping
dipping134014832dipping
doping103919462do_ping
dropping14309282dropping
dupping133711042dupping
estopping1434792estopping
flopping16388772flopping
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
stepping13329072stepping
stomping13309762stomping
stooping113012362stooping
stoping103716622sto_ping
stoppling1474962stoppling
stropping1436932stropping
supping123814532supping
swopping16377962swopping
tamping122815812tamping
taping94222392t_aping
tappings13267712tappings
temping122710692temping
tippling13196702tippling
toeing74418472to_eing
togging103512742togging
toiling83219022toiling
toiting83217092toiting
toking114420722to_king
toling73926122to_ling
tolling83418562tolling
tombing123310532tombing
tomming12359242tomming
tonging93314512tonging
toning74025792to_ning
tooling82918312tooling
tooting83019422tooting
topline92313182topline
topspin1145112topspin_
topspins1244872topspins
tossing83612562tossing
toting74123792to_ting
totting82816842totting
touring82915192touring
tousing82916992tousing
touting84118452touting
towing103823192to_wing
toying105017302to_ying
trapping132911392trapping
tripping133210922tripping
tromping13319602tromping
trooping112710282trooping
trouping11249502trouping
tumping123114242tumping
typing124110582t_yping
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.373479064.3
2DLD Change Limit1076711263.29632667.2
3Display Results1261260.0502520.0
 (SQL Overall)1786911263.71948048.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.