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

149 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
shoppings1729507(None) 
hoppings16306521_hoppings
shippings17275681shippings
shopping163611291shopping_
chopping183710262chopping_
droppings15264502droppings
hopping154115272_hopping_
shipping163611252shipping_
shootings13266062shootings
shorings12269482sho_rings
showings15246882sho_wings
showrings1644062showrings
slopping133811422slopping_
sopping123917202s_opping_
stopping133611412stopping_
swopping16377962swopping_
toppings13286422_toppings
whippings20284182whippings
whopping19357372whopping_
bopping143512033_bopping_
cappings15369493_cappings
chapping183710723chapping_
chipping18389793chipping_
chomping18339883chomping_
chopines152711733cho_pines
chopins142312243cho_pin_s
choppiness1973563choppiness
cioppinos1542203cioppinos
clippings16273753clippings
clopping153511083clopping_
copings124111843_co_pings
copping143918593_copping_
cropping153210883cropping_
cuppings15336053_cuppings
dopings11408783_do_pings
drippings15313903drippings
dropping14309283dropping_
estopping1434793estopping_
flopping16388773flopping_
fopping153511133_fopping_
ghostings1433483ghostings
glopping14307753glopping_
groupings13273813groupings
happing153817233_happing_
harpings14379773_harpings
helpings14255653_helpings
hipping153915103_hipping_
holdings13297743_holdings
hooping133615703_hooping_
hoping123719743_ho_ping_
hoppling16206763_hoppling_
hornings12238363_hornings
housings12307483_housings
lippings13296093_lippings
lopping123815223_lopping_
mappings15296413_mappings
mopping143411473_mopping_
plopping12318703plopping_
popping113715413_popping_
propping122811673propping_
samplings1435553samplings
saplings11269803s_aplings
sapping123519313s_apping_
schoolings1644013schoolings
scoldings13224133scoldings
scooping133610633scooping_
scoping123513823sco_ping_
scourings12235293scourings
scoutings12306143scoutings
scrapings14255173scrapings
shadings13327433sh_adings
shaftings16224183shaftings
shaping133116183sh_aping_
sharping143011373sharping_
shavings15356333sh_avings
shealings13317563shealings
shearings13337563shearings
sheetings13256713sheetings
shelvings16283823shelvings
shielings13237123shielings
shillings13348093shillings
shippens15316803shippen_s
shippons15255663shippon_s
shirrings13245323shirrings
shirtings13276603shirtings
shlepping1733393shlepping_
shoaling123111753shoaling_
shocking184311543shocking_
shoeing113211883sho_eing_
shogging14308023shogging_
shooing112112913sho_oing_
shooling123012563shooling_
shooting122812863shooting_
shopgirls1541793shopgirls
shoplifts1742763shoplifts
shoppers153010763shopp_ers
shoppes143411403shopp__es
shoring112820073sho_ring_
shorting122514803shorting_
shotting123012383shotting_
shouting122711793shouting_
shoving142910643sho_ving_
showing143814663sho_wing_
showring1548323showring_
shuckings19273853shuckings
sipping123117433s_ipping_
skipping17297603skipping_
slapping133510843slapping_
sleepings12335883sleepings
slipping133510663slipping_
sloping104114073slo_ping_
sloppiness1443753sloppiness
smockings18264283smockings
snapping13349653snapping_
snipping13308853snipping_
snooping113811323snooping_
soaping103616223s_oaping_
soarings93210393s_oarings
soppiness1336543s_oppiness
sorings83817253s_o_rings
souping104215533s_ouping_
spoolings12245393spoolings
spoutings12245153spoutings
springs104415923s__prings
stepping13329073stepping_
stipplings1582373stipplings
stockings16296093stockings
stomping13309763stomping_
stooping113012363stooping_
stoping103716623sto_ping_
stoppling1474963stoppling_
strappings1543353strappings
stripings12215203stripings
stropping1436933stropping_
supping123814533s_upping_
swapping16348673swapping_
sweepings15345633sweepings
swooping14338403swooping_
tappings13267713_tappings
topping123514623_topping_
trappings14265753trappings
trippings14225723trippings
uppings12257123__uppings
whapping19317113whapping_
whipping19328173whipping_
whomping19285943whomping_
whooping17286633whooping_
whupping19345243whupping_
wrappings17253713wrappings

Search took 7 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.423422437.4
2DLD Change Limit1486411496.12324275.8
3Display Results1491490.0632365.1
 (SQL Overall)1786911496.60927037.5
 
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.