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

76 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
overclean1411526(None) 
overcleans15134881overcleans
overclear14134741overclear
overcheap1953512overcheap
overcleaned1744712overcleaned
overclears15134322overclears
overleaf14237972over_leaf
overleap13237832over_leap
overlearn1235902over_learn
overplan13258942overpl_an
cerulean1053773_cerulean
herculean1452113_herculean
overalert12411113overalert
overbear13228883over_bear
overbeat132713833over_beat
overbleach2042553overbleach
overblew1636223overble_w
overblown1743953overblown
overclaim1645333overclaim
overclass1436963overclass
overcleaning1844933overcleaning
overcleared1744533overcleared
overclearing1845153overclearing
overclose1447013overclose
overcloud1544743overcloud
overcoat13312103overc_oat
overcram1537073overc_ram
overdear12248083over_dear
overeat102620323over__eat
overfear14247403over_fear
overflew1735593overfle_w
overflown1843713overflown
overglad13116533overgl_ad
overgreat1347713overgreat
overhead152110363over_head
overheap16257343over_heap
overhear14249413over_hear
overheat142413773over_heat
overkeen15227103over_keen
overlain112112443over_lain
overland122312003over_l_and
overlap12239833over_l_ap
overlax17238413over_l_ax
overlay132410833over_l_ay
overleaps14226783over_leaps
overleapt14247883over_leapt
overlearns1344993over_learns
overlearnt1346003over_learnt
overlend122510103over_lend
overlent112715293over_lent
overlet102619033over_le_t
overlets112312363over_lets
overlewd15216273over_lewd
overload12119283over_load
overman12311463over__man
overmen12311803over_me_n
overnear11238473over_near
overneat112713643over_neat
overplans14249573overpl_ans
overplant142510713overpl_ant
overplay16257553overpl_ay
overran10311663over__ran
oversea102412113over_sea_
overseas112612423over_seas
overseen112612173over_seen
oversewn14266933over_sewn
oversleep1445433oversleep
overslept1446853overslept
overtreat1249373overtreat
overweak18216073over_weak
overwear14248603over_wear
overween14218513over_ween
overzeal2076093over_zeal
preclean1245893pre_clean
reclean938523_re_clean
superclean1445403superclean

Search took 7 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.420425454.8
2DLD Change Limit148641766.08024447.5
3Display Results76760.0302533.3
 (SQL Overall)178691766.53027364.6
 
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.