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

131 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
overruled1312781(None) 
overrule11149671overrule_
overrules12129091overrules
ferruled1263922_ferruled
overalled1339062overalled
overcured15148642overcured
overhauled1775392overhauled
overrated13313082overrated
overrude12168092overrude_
overruffed2042902overruffed
overtured13169212overtured
overurged1496672overurged
overused1249442ove_rused
averred11237593averr__ed
coveralled1644183coveralled
ferreled1234833_ferreled
ferrule1035863_ferrule_
ferrules1136163_ferrules
feruled11318413_fe_ruled
opercule1245283opercule_
opercules1345573opercules
overable13513573overable_
overacted1539633overacted
overaged13511673ove_raged
overarched1946093overarched
overarmed1538103overarmed
overawed1579963ove_rawed
overbaked19127823overbaked
overbed132811843ove_r_bed
overbilled1645413overbilled
overblew1636213ove_rblew
overboiled1646123overboiled
overbold14208533overbol_d
overbraked2046043overbraked
overbred1459843ove_rbred
overbreed1548033overbreed
overbuild15154683overbuild
overburned1664663overburned
overcalled1646493overcalled
overcold14208483overcol_d
overcooled1646223overcooled
overcure132210053overcure_
overcures14139993overcures
overdared1439163overdared
overdosed14128073overdosed
overdried1439013overdried
overdubbed1942273overdubbed
overdue11138953overdu_e_
overdyed16126513ove_rdyed
overed102216623ove_r__ed
overfed142510253ove_r_fed
overfeed15299433ove_rfeed
overfilled1745043overfilled
overflew1735593ove_rflew
overfull1435923overful_l
overfund1535813overfu_nd
overfunded1844293overfunded
overgild1336583overgil_d
overgilded1644333overgilded
overglad13116533ove_rglad
overgraded1656593overgraded
overgrazed2466003overgrazed
overhated16610443overhated
overheld15197363overhel_d
overhold15219003overhol_d
overhoped1837093overhoped
overhunted1745173overhunted
overhyped2144153overhyped
overidle1248823overidle_
overjoyed2334783overjoyed
overkilled1844263overkilled
overladed1459223overladed
overlend122510103ove_r_lend
overlet102619033ove_r_let
overlewd15216263ove_r_lewd
overlived16248513overlived
overloved16217643overloved
overmelted1646893overmelted
overmild1436983overmil_d
overmilked2044173overmilked
overmined1539603overmined
overmixed2236063overmixed
overmuscled1952253overmuscled
overplied1539053overplied
overpriced18107523overpriced
overprized2587633overprized
overpumped2043523overpumped
overrate11615693overrate_
overrates12414623overrates
override121512523override_
overrides131411013overrides
overrife14169933overrife_
overrigid1444603overrigid
overripe131410383overripe_
overrode121810573overrode_
overruff1794103overru_ff
overruffs1883203overruffs
overruling1467613overruling
overrun1038023overru__n
overruns1138173overru_ns
oversale11313873oversale_
oversales12313143oversales
oversalted1447683oversalted
oversauced1645723oversauced
oversaved1638613oversaved
overscaled1646453overscaled
overseed122513343ove_rseed
oversewed1636933oversewed
oversexed2037203oversexed
oversized221710153oversized
oversold12218923oversol_d
oversudsed1543973oversudsed
oversupped1844073oversupped
oversure111611163oversure_
overtalked1845583overtalked
overtaxed20117243overtaxed
overtimed15159243overtimed
overtired131310253overtired
overtoiled1446283overtoiled
overtraded1557073overtraded
overtrumped1952633overtrumped
overture111511683overture_
overtures121611453overtures
overturned1445303overturned
overurge1277103overurge_
overurges1387483overurges
overuse10310923ove_ruse_
overuses11312643ove_ruses
overvalued1744703overvalued
overvoted1637503overvoted
verdured13255763_verdured

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.1561145455.1
2DLD Change Limit1486411319.56315543.3
3Display Results1311310.0462847.8
 (SQL Overall)1786911319.76518299.1
 
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.