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

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

90 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
restocking174570(None) 
restacking1737181restacking
restoking1438191resto_king
recocking18138372re_cocking
redocking17126782re_docking
relocking16137682re_locking
resoaking1439372res_oaking
restoring10314612resto_ring
restriking1548042restriking
retacking1658972re_tacking
stocking152912502__stocking
bemocking2034653be_mocking
besmoking18114613besmo_king
bestowing1535803besto_wing
bluestocking215863bluestocking
defrocking2143153defrocking
deticking1736043de_ticking
estopping1434793_estopping
festooning1444493festooning
overstocking2243643overstocking
peacocking2143313peacocking
presoaking1736253pres_oaking
prestoring13310303presto_ring
reattacking1843303reattacking
rebooking16146393re_booking
rechecking2244463rechecking
recking144319923re___cking
recooking16148543re_cooking
recorking16149643re_corking
reevoking1734223reevo_king
relooking14167143re_looking
repacking1838283re_packing
reracking1639313re_racking
rescoring12310603resco_ring
rescuing1139623res__cuing
resecting122816483res_ecting
reseeking14208493res_eeking
reshoeing1336593resho_eing
reshooting1436223reshooting
reshowing1646633resho_wing
resodding1237203res_odding
resoling92916303res_o_ling
resolving1337743res_olving
resorbing1269353res_orbing
resorting10614613res_orting
resowing123111523res_o_wing
respacing1438893respac_ing
respeaking1736803respeaking
respecting1549883respecting
responding1437403responding
respooling1355743respooling
respotting1347113respotting
restabling1337653restabling
restaffing1744193restaffing
restaging112410853rest_aging
restamping1565213restamping
restarting11310663restarting
restating102319413rest_ating
resting85031183rest___ing
restitching1744003restitching
restock1338673restock___
restocked1655173restock_ed
restocks1437503restock__s
restricting1449303restricting
restring91518783rest__ring
restriving1448133restriving
restudying1543423restudying
restuffing1743163restuffing
restyling1337923rest_yling
retackling1744433re_tackling
retaking133114283re_t_aking
retching143412173re_t_ching
retooling1039093re_tooling
retorting10613273re_torting
retouching1644693re_touching
retracking1738163retracking
revoking1637803re_vo_king
reworking17136873re_working
rocking143619633r___ocking
shocking184311543__shocking
smocking17349103__smocking
socking143518603__s_ocking
stacking154215083__stacking
sticking153513463__sticking
stockings16296093__stockings
stoking123615593__sto_king
stooking132711143__stooking
tictocking19112833tictocking
unstacking1744993unstacking
unsticking1744943unsticking

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 Filter1786911406030.406440125.6
2DLD Change Limit140603906.40621948.6
3Display Results90900.0461956.5
 (SQL Overall)178691906.85826055.8
 
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.