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

113 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
overcrowding224397(None) 
overbrowsing2143802overbrowsing
overclouding1943642overclouding
overcropping2244282overcropping
overgrowing1945702overgrow_ing
becrowding1943373_be_crowding
outcrowding1843493o_utcrowding
overblowing2044943overblow_ing
overbreeding1944443overbreeding
overcoming1848733overc_o_ming
overcooking2145793overc_ooking
overcooling1746843overc_ooling
overcramming2244593overcramming
overcrowd1844583overcrowd___
overcrowded2143183overcrowd_ed
overcrowds1943093overcrowd__s
overdrawing1956683overdraw_ing
overflooding2053253overflooding
overflowing2144813overflow_ing
overgoading1746563over_goading
overgrading1747513overgr_ading
overholding1955643over_holding
overloading1647333over_loading
overlording1647463over_lording
overriding1548513over_r_iding
overthrowing2243183overthrow_ing
overtrading1648263overtr_ading
crowding15247934____crowding
decrowning1743594_de_crowning
escrowing1544814__escrow_ing
outcrowing1645994o_utcrow_ing
overarching2056894overar_ching
overarming1639234overar__ming
overawing16710294ove__raw_ing
overbidding1944724over_bidding
overboiling1746844over_boiling
overbooking2145184over_booking
overborrowing2252114overborrow_ing
overbraking2147144overbr_aking
overbriefing2153434overbriefing
overbuilding1943794overbuilding
overcalling1747324overc_alling
overcasting1748514overc_asting
overcharging2244224overcharging
overchilling2154114overchilling
overclaiming2045084overclaiming
overcleaning1844934overcleaning
overclearing1845154overclearing
overcoaching2344504overcoaching
overcoloring1844694overcoloring
overcounting1846614overcounting
overcuring16108764overc__uring
overcutting1746824overc_utting
overdoing1439144over_do__ing
overdosing1547544over_do_sing
overdressing1745734overdressing
overdrinking2143974overdrinking
overdriving1946094overdr_iving
overdrying1846544overdr__ying
overemoting1747314overemo_ting
overfeeding1945914over_feeding
overfunding1945384over_funding
overgilding1795204over_gilding
overgirding17105644over_girding
overgrazing2566774overgr_azing
overgrown1644284overgrow__n_
overhanding1947024over_handing
overhoping1947044over_ho_ping
overjoying2445144over_jo_ying
overlading1539324ove__rlading
overlending1647614over_lending
overlooking1945414over_looking
overloving1746634over_lo_ving
overpeopling2044774overpeopling
overplotting1845044overplotting
overpowering2144464over_powering
overpraising1846134overpraising
overpricing1947734overpr_icing
overprinting1846874overprinting
overprizing2648034overpr_izing
overproducing2253544overproducing
overpromising2153964overpromising
overpromoting2153964overpromoting
overrating14814204over_r_ating
overroasting1646094over_roasting
overruffing2144234over_ruffing
overruling1467614over_r_uling
overrunning1545054over_running
overscoring1746834oversco_ring
overseeding1647004over_seeding
oversewing1747434over_sew_ing
overshading1946644over_shading
overshooting1944604overshooting
oversmoking2145044oversmo_king
oversoaking1956784over_soaking
overspending1945734overspending
overspreading2053604overspreading
overstocking2243644overstocking
overstrewing1944674overstrew_ing
overstriding1745614overstriding
overswing1638454ove__rsw_ing
overtoiling1547194over_toiling
overtopping1945654over_topping
overtraining1646024overtraining
overtreating1648554overtreating
overtrimming2053744overtrimming
overtrumping2053334overtrumping
overurging1547114overur__ging
overvoting1747534over_vo_ting
overwinding1955754over_winding
overworking2246034over_working
overwriting1847904overwr_iting
recrowning1645214_re_crowning

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.423422437.4
2DLD Change Limit1247901136.53019110.3
3Display Results1131130.0631793.7
 (SQL Overall)1786911137.01625469.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.