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

51 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
overzealous235204(None) 
overzeals2165762overzeal__s
overserious1453943overserious
overzeal2076093overzeal___
overalls11410394over__al_ls
overanxious2152104overanxious
overbears14208484overbea__rs
overbeats14279824overbea__ts
overblouse1544014over__blouse
overblows1745004over__blows
overcalls1447204over_cal_ls
overcloud1544744over__cloud
overclouds1643494over__clouds
overcolors15124824over_colors
overcredulous196884overcredulous
overdevelops2161504overdevelops
overeaters1348634over_eaters
overeats112415264over_ea__ts
overfavors1942384over_favors
overfears15236944overfea__rs
overflows1845114over__flows
overgenerous1662264overgenerous
overheads16248934overhea__ds
overheaps17226954overhea__ps
overhears15258874overhea__rs
overheats15229994overhea__ts
overlabors1543224over_labors
overleaps14226784overlea__ps
overlearns1344994overlea_rns
overloud12117754over___loud
overmelts1447264overme_l_ts
overobvious1951874overobvious
overpedals1643434overpedal__s
overplots1436954over__plots
overplus1336064over__pl_us
overreaches1944524overreaches
overreacts1545434overrea_cts
oversales12313144over_sal_es
oversalts1238164over_sal_ts
overseas112612424oversea___s
oversells1236974overse_l_ls
overshadows2151594overshadows
overtalks1645664over_tal_ks
overteaches1944104overteaches
overvalue1545454over_val_ue
overvalues1644964over_values
overwearies1746404overwearies
overwears15227874overwea__rs
overzealousness277814overzealousness
unzealous1842734__unzealous
zealous1637814____zealous

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.406440125.6
2DLD Change Limit148819519.14016282.2
3Display Results51510.0331545.5
 (SQL Overall)178691519.57918654.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.