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

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

71 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
meatpacking225221(None) 
meatpackings2351101meatpackings
reattacking1843302reattacking
attacking1635323__attacking
medevacking2451903medevacking
medivacking2451583medivacking
reattaching1743123reattaching
repacking1838283re__packing
restacking1737183rest_acking
retacking1658973re_t_acking
retracking1738153re_tracking
attaching1545434__attaching
backpacking2353324backpacking
barracking1944704_barracking
betaking153010144be_t_a_king
bethanking2044294be_thanking
carjacking2643544_carjacking
catfacing1744554_catfac_ing
deadlocking2051714deadlocking
deadpanning1651564deadpanning
detaching1637264de_t_aching
deticking1736044de_t_icking
detracting1438714de_tracting
earmarking1743574_earmarking
extracting2047224_extracting
henpecking2242304he_npecking
mafficking2542644m_afficking
magicking19113544m_a_gicking
mammocking2052394m_ammocking
manacling1446284m_a_nacling
mapmaking2044614m_a_pmaking
massacring1543584m_assacring
matching163512394m_at__ching
medevacing1942854medevac_ing
medivacing1943044medivac_ing
menacing1339774me__nac_ing
metaling111613714me_t_a_ling
metalling1249594me_t_alling
misspacing1784984misspac_ing
mistaking1699684mist_a_king
misteaching1944534misteaching
mistracing1569604mistrac_ing
nitpicking1943034_nitpicking
outpacing1478364_outpac_ing
overpacking2346534overpacking
packing164420724____packing
peacocking2143314pea_cocking
peptalking1943254pept_alking
prepacking2145774_prepacking
ransacking1744424_ransacking
reattaining1244594reattaining
reawaking17216064rea_wa_king
reparking1638924re__parking
reracking1639304re__racking
respacing1438894re_spac_ing
restocking1745704rest_ocking
retackling1744434re_t_ackling
retaking133114274re_t_a_king
reteaching1636024re_teaching
retracing12313284re_trac_ing
retracting13311934re_tracting
stacking154215084__st_acking
tacking144421484___t_acking
tarmacking1944224_tarmacking
thacking183110044___thacking
tictacking19113314tict_acking
tracking153715464___tracking
unpacking1835134__unpacking
unstacking1744994unst_acking
untacking1636644_unt_acking
untracking1746934_untracking

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit148819719.06316420.5
3Display Results71710.0461543.5
 (SQL Overall)178691719.26519286.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.