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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
overstaffing224365(None) 
overstuffing2253051overstuffing
overstating15410732oversta_ting
overstaying1847052oversta_ying
overruffing2144233over_ruffing
oversalting1548573overs_alting
oversaucing1746263overs_aucing
oversaving1738163overs_a_ving
overshading1946643oversha_ding
oversoaking1956783oversoa_king
overstaff1844483overstaff___
overstaffed2153043overstaff_ed
overstaffs1943063overstaff__s
oversteering1645313oversteering
overstepping2044083overstepping
overstirring1644533overstirring
overstocking2243643overstocking
overstraining1754133overstraining
overstrewing1944673overstrewing
overstriding1745613overstriding
overstudying2043173overstudying
overtaking1878893over_ta_king
overtalking1976693over_talking
overtasking1986153over_tasking
overtaxing2157693over_ta_xing
restaffing1744193_re_staffing
understaffing21102733understaffing
overacting16310914over__acting
overarming1639234over__arming
overawing16710294over__a_wing
overbaking2067774over_ba_king
overbearing1748424overbea_ring
overbeating17410484overbea_ting
overbraking2147144overbra_king
overbriefing2153434overbriefing
overcalling1747324over_calling
overcasting1748514over_casting
overcharging2244224overcharging
overclaiming2045084overclaiming
overcoaching2344504overcoaching
overcramming2244594overcramming
overdaring1539504over_da_ring
overdrawing1956684overdra_wing
overeating141016534over_ea_ting
overfearing1847554overfea_ring
overglazing2545974overgla_zing
overgoading1746564overgoa_ding
overgrading1747514overgra_ding
overgrazing2566774overgra_zing
overhanding1947024over_handing
overhanging1946324over_hanging
overhating17910954over_ha_ting
overhauling1846034over_hauling
overheaping2046794overhea_ping
overhearing1847844overhea_ring
overheating1849934overhea_ting
overlading1539324over_la_ding
overlapping1945414over_lapping
overlaying1738444over_la_ying
overleaping1747444overlea_ping
overlearning1644714overlearning
overloading1647334overloa_ding
overmanning1745944over_manning
overmatching2353674overmatching
overpacking2346534over_packing
overpassing1746644over_passing
overpaying1937954over_pa_ying
overplanning1844564overplanning
overplanting1846974overplanting
overplaying2047344overpla_ying
overpraising1846134overpraising
overrating14814204over_ra_ting
overreaching2175174overreaching
overreacting1856664overreacting
overroasting1646094overroasting
overscoring1746834overs_coring
overseeding1647004overs_eeding
overseeing1438384overs__eeing
overselling1547794overs_elling
oversetting1548814overs_etting
oversewing1747434overs__ewing
overshadowing2451684overshadowing
overshooting1944604overshooting
overslaughing2152084overslaughing
oversleeping1843814oversleeping
overslipping2043494overslipping
oversmoking2145044overs_moking
overspending1945734overspending
overspicing1946544overs_picing
overspilling1844534overspilling
overstrain1347044overst_rain_
overstrains1447164overst_rains
overstressing1753714overstressing
overstrung1444374overst__rung
overstuff1843464overstuff___
overstuffed2162444overstuff_ed
overstuffs1942364overstuff__s
oversudsing1645014overs_udsing
oversupping1945214overs_upping
overswing1638454overs___wing
overswinging2053544overswinging
overteaching2174924overteaching
overtiming1699074over_t_iming
overtipping1945234over_tipping
overtiring141210204over_t_iring
overtoiling1547194over_toiling
overtopping1945654over_topping
overtrading1648264over_trading
overtraining1646024overtraining
overturing1499414over_t_uring
overturning1545974over_turning
overvaluing1845284over_valuing
overwarming2046304over_warming
overwatching2453404overwatching
overwatering1954934overwatering
overwearing1847714overwea_ring
overwearying2244104overwearying
restuffing1743164_re_stuffing
staffing15247494____staffing
understaffings22121594understaffings
versifying2045034_vers_ifying

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901216.70318617.0
3Display Results1211210.0761592.1
 (SQL Overall)1786911217.18524870.0
 
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.