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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
oversleep144543(None) 
oversleeps1553251oversleeps
overleap13237832over_leap
oversee102717602overs_ee_
overseed122513342overs_eed
overseen112612172overs_een
overseer112611072overs_eer
oversees112415902overs_ees
overslept1446852overslept
overslip1336322oversl_ip
oversteer1246412oversteer
overstep1338032overs_tep
oversweet1548892oversweet
coverslip1643273coversl_ip
outsleep1046013o_utsleep
overalert12411113overalert
overalled1339063overalled
overblew1636213overbl_ew
overbreed1548023overbreed
overcheap1953513overcheap
overclean14115263overclean
overclear14134743overclear
overfeed15299433over_feed
overflew1735593overfl_ew
overflies1539103overflies
overfree1439003overfree_
overheap16257343over_heap
overkeen15227103over_keen
overlap12239833over_l_ap
overleaf14237973over_leaf
overleaps14226783over_leaps
overleapt14247883over_leapt
overlend122510103over_lend
overlent112715293over_lent
overlet102619033over_l_et
overlets112312363over_lets
overlewd15216263over_lewd
overlie102615013over_lie_
overlies112417043over_lies
overmeek1735493over_meek
overplied1539053overplied
overplies14310463overplies
oversale11313873oversale_
oversales12313143oversales
oversalted1447683oversalted
oversave14310493oversave_
oversaved1638613oversaved
oversaves15310183oversaves
oversea102412113overs__ea
overseas112612423overs_eas
overseeded1545433overseeded
overseeds13248893overseeds
overseers12298783overseers
oversell1137473overs_ell
oversells1236973oversells
overset102821473overs__et
oversets113114173overs_ets
oversew132810833overs__ew
oversewed1636923oversewed
oversewn14266933overs_ewn
oversews14289423overs_ews
oversexed2037203oversexed
oversharp1743753oversharp
overshoe1438563overshoe_
overshoes1538863overshoes
overside122013933overside_
oversides131512663oversides
oversize201812513oversize_
oversized221710153oversized
oversizes211111613oversizes
oversleeping1843813oversleeping
overslips1446763overslips
overslipt1447743overslipt
overslow1435693oversl_ow
overspend1545883overspend
overspent1449923overspent
oversteers1344863oversteers
oversteps1436303oversteps
overstrew1546483overstrew
oversup1236043overs__up
oversure111611163oversure_
overween14218503over_ween
presleep1244483pre_sleep

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641837.75019179.5
3Display Results83830.0461804.3
 (SQL Overall)178691837.95222471.2
 
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.