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

108 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
estopping143479(None) 
stopping133611411_stopping
shopping163611292_shopping
slopping133811422_slopping
sopping123917202_s_opping
stepping13329072_stepping
stomping13309762_stomping
stooping113012362_stooping
stoping103716622_sto_ping
stoppling1474962_stoppling
stropping1436932_stropping
swopping16377962_swopping
topping123514622__topping
unstopping1543752unstopping
astonying1345233astonying
bestowing1535803besto_wing
bopping143512033__bopping
chopping183710263_chopping
clopping153511083_clopping
copping143918593__copping
cropping153210883_cropping
dropping14309283_dropping
eloping103512833e_lo_ping
entoiling1038483entoiling
entombing1444893entombing
entrapping1544873entrapping
equipping2342843equipping
escaping1347063es_caping
escarping1435203escarping
escorting1237713escorting
escoting1158713esco_ting
espousing1265003espousing
espying1336193es__pying
estating92614993est_ating
esteeming1244703esteeming
estoppage1452353estoppage
estopped1334993estopp_ed
estoppel1243173estopp_el
estoppels1342353estoppels
estraying1338293estraying
extolling1744623extolling
extorting1746763extorting
festooning1444493festooning
flopping16388773_flopping
fopping153511133__fopping
glopping14307753_glopping
hopping154115273__hopping
lopping123815223__lopping
misstopping1852433misstopping
mopping143411473__mopping
overtopping1945653overtopping
plopping12318703_plopping
popping113715413__popping
propping122811673_propping
reshipping1843793reshipping
restamping1565213restamping
restocking1745703restocking
restoking1438193resto_king
restoring10314613resto_ring
sapping123519313_s_apping
scooping133610633_scooping
scoping123513823_sco_ping
shipping163611253_shipping
shoppings17295073_shoppings
sipping123117433_s_ipping
skipping17297603_skipping
slapping133510833_slapping
slipping133510663_slipping
sloping104114073_slo_ping
snapping13349653_snapping
snipping13308853_snipping
snooping113811323_snooping
soaping103616223_s_oaping
souping104215533_s_ouping
stamping133310963_stamping
stapling112813153_stapling
steeping113412583_steeping
stippling1475173_stippling
stobbing13227243_stobbing
stocking152912503_stocking
stodging11277463_stodging
stoking123615593_sto_king
stoning83717443_sto_ning
stooging102810043_stooging
stooking132711143_stooking
stooling93113133_stooling
stoppering1544613_stoppering
storing83921123_sto_ring
storming11209423_storming
storying12249673_storying
stotting92811163_stotting
stowing113315133_sto_wing
strapping1436993_strapping
striping112612523_striping
stripping1436493_stripping
stumping13289083_stumping
supping123814533_s_upping
swapping16348673_swapping
swooping14338403_swooping
tapping123317133__tapping
tipping122814973__tipping
toping94122993__to_ping
toppings13286423__toppings
toppling13197353__toppling
tupping123411663__tupping
unstepping1543443unstepping
upstepping1442103upstepping
whopping19357373_whopping

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411086.98621277.0
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.43824024.1
 
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.