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

61 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
overoperates1711661(None) 
overoperate1676691overoperate_
overoperated1876041overoperated
overoperating1956723overoperating
overpopulates2094593overpopulates
overrates12414623over___rates
reoperates1249663_re_operates
cooperates1469614__cooperates
exonerates17107344__exonerates
governorates1652764gover_norates
operates10515414____operates
overbeaten1547714over_be_aten
overbeats14279824over_be_at_s
overbrakes1946504over__brakes
overcompensates2482844overcompensates
overdecorates1953434overdecorates
overeaten12312784over__e_aten
overeater12312484over__e_ater
overeaters1348634over__e_aters
overeats112415274over__e_at_s
overeducates1854394overeducates
overemotes1546704over__emotes
overexerted2245274overexer_ted
overexerts2044744overexer_t_s
overgrades1556934over__grades
overgrazes2356284over__grazes
overhates15311944over___hates
overheated1739484over_he_ated
overheats15229994over_he_at_s
overinflates1853954overinflates
overpedaled1844304over_pedaled
overpedals1643434over_peda_ls
overpeoples1854114over_peoples
overpersuades19112144over_persuades
overpert13312994over_per_t__
overpopulate19114684overpopulate_
overpopulated2194414overpopulated
overpraise1547424over_p_raise
overpraises1646384over_p_raises
overprices17108524over_p_rices
overprizes24107914over_p_rizes
overrate11615694over___rate_
overrated13313084over___rated
oversaturates1654214oversaturates
overspeculates21133404overspeculates
overspreads1742824oversprea_ds
overstates131110114over__states
overtrades1457494over__trades
overtreated1547424overtre_ated
overtreats1346644overtre_at_s
overwearies1746404over_wearies
overwrites1658114over__writes
perorates11417024_pero__rates
perpetrates1566204_per_petrates
recuperates1545604_recuperates
reoperate11410184_re_operate_
reoperated1348154_re_operated
reverberates1753514rever_berates
venerates12312264_ve__nerates
vertebrates1693564_vertebrates
vituperates1652394_vituperates

Search took 9 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 Limit124790617.65616299.6
3Display Results61610.0461326.1
 (SQL Overall)178691618.10822038.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.