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

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

134 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
overrules1212909(None) 
overrule11149671overrule_
overruled13127811overruled
ferrules1136162_ferrules
opercules1345572opercules
overcures14139992overcures
overrates12414612overrates
overrides131411012overrides
overrude12168092overrude_
overruffs1883202overruffs
overruns1138172overru_ns
oversales12313142oversales
overtures121611442overtures
overurges1387482overurges
overuses11312642ove_ruses
covertures1545453covertures
ferrule1035863_ferrule_
ferruled1263923_ferruled
ferules103112723_fe_rules
hercules1337633_hercules
nervules1145013_nervules
operceles1344613operceles
opercule1245283opercule_
ovarioles1244603ovarioles
overable13513573overable_
overages12513833ove_rages
overalled1339063overalled
overalls11410393ove_ralls
overarches1846833overarches
overawes14511183ove_rawes
overbakes18129123overbakes
overbills1446603overbills
overbites14310973overbites
overblew1636213ove_rblew
overbrakes1946493overbrakes
overbuilds1642973overbuilds
overburns14135613overburns
overbuys1644833overbu_ys
overcalls1447203overcalls
overcomes161110333overcomes
overcure132210053overcure_
overcured15148643overcured
overcuts1337513overcu_ts
overdares13310673overdares
overdoes121212543ove_rdoes
overdoses13119793overdoses
overdries13310883overdries
overdrives1746113overdrives
overdubs1494573overdu_bs
overdue11138953overdu_e_
overdyes15127473ove_rdyes
overfills1545703overfills
overflew1735593ove_rflew
overflies1539103overflies
overfull1435923overful_l
overfunds1644593overfunds
overgilds1445183overgilds
overgrades1556923overgrades
overgrazes2356273overgrazes
overhates15311933overhates
overhauled1775393overhauled
overhauls1545513overhaul_s
overholds16206323overholds
overhopes1738143overhopes
overhunts15245743overhunts
overhypes2044623overhypes
overidle1248823overidle_
overkills1644873overkills
overlades13510353overlades
overlet102619033ove_r_let
overlets112312363ove_r_lets
overlies112417043ove_rlies
overlives152210143overlives
overloves15218673overloves
overmelts1447263overmelts
overmilks1844453overmilks
overmines14312683overmines
overmixes2137323overmixes
overmuches2044113overmuches
overplies14310463overplies
overplus1336063ove_rplus
overpluses1545783overpluses
overprices17108523overprices
overprizes24107913overprizes
overpumps1843433overpumps
overrate11615683overrate_
overrated13313073overrated
override121512523override_
overrife14169933overrife_
overripe131410383overripe_
overrode121810573overrode_
overruff1794103overru_ff
overruffed2042903overruffed
overruling1467613overruling
overrun1038023overru__n
oversale11313873oversale_
oversalts1238163oversalts
oversauces1546483oversauces
oversaves15310183oversaves
oversees112415903ove_rsees
oversells1236973oversells
overshoes1538863overshoes
oversides131512663oversides
oversizes211111613oversizes
oversouls1236603oversoul_s
oversuds1237033oversu_ds
oversudses1444303oversudses
oversups1336553oversu_ps
oversure111611163oversure_
overtakes16119813overtakes
overtalks1645663overtalks
overtaxes19118793overtaxes
overtimes141511303overtimes
overtires121412363overtires
overtones121011853overtones
overtrades1457483overtrades
overtrumps1742553overtrumps
overture111511683overture_
overtured13169213overtured
overturns12136623overturns
overurge1277103overurge_
overurged1496673overurged
overuse10310923ove_ruse_
overused1249443ove_rused
overvalues1644963overvalues
overvotes1538423overvotes
overwrites1658103overwrites
ovules938223ov___ules
veinules1135913_veinules
venules104011483_ve_nules
verbiles1338913_verbiles
verdures12247743_verdures
verrucas1343923_verrucas
virgules1244333_virgules

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411349.09616341.4
3Display Results1341340.1101218.2
 (SQL Overall)1786911349.37619058.3
 
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.