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

94 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
overmelts144726(None) 
overmelt13310711overmelt_
averments1449092averments
overbeats14279822overbeats
overbets132510682overbe_ts
overeats112415262over_eats
overheats15229992overheats
overlets112312362overle_ts
overmelted1646902overmelted
overmilks1844452overmilks
oversalts1238162oversalts
oversells1236972oversells
oversets113114172overse_ts
overwets14219952overwe_ts
averment13311603averment_
cermets1139713_cerme_ts
coverlets1437053coverle_ts
ferments13311473_ferments
governments1755423governments
movements1647513move_ments
operceles1344613operceles
overacts1339653over_acts
overalls11410393over_alls
overbears14208483overbears
overbeat132713833overbeat_
overbet122716063overbe_t_
overbills1446603overbills
overcalls1447203overcalls
overcasts14217853overcasts
overcoats1438863overcoats
overcuts1337513over_cuts
overdecks1944573overdecks
overeat102620323over_eat_
overedits1346813overedits
overemote1447193overemote
overemotes1546703overemotes
overexerts2044743overexerts
overfears15236943overfears
overfeeds16226023overfeeds
overfills1545703overfills
overgilds1445183overgilds
overgilt1239623overgilt_
overheads16248933overheads
overheaps17226953overheaps
overhears15258873overhears
overheat142413773overheat_
overheld15197373overhel_d
overholds16206333overholds
overhunts15245743overhunts
overkills1644873overkills
overleaps14226783overleaps
overlends13237523overlends
overlent112715293overlent_
overlet102619033overle_t_
overmans13310313overm_ans
overmeek1735493overme_ek
overmelting1768113overmelting
overmen12311803overme__n
overmild1436983overmil_d
overmilk1735553overmil_k
overmines14312683overmines
overmixes2137323overmixes
overneat112713643overneat_
overpert13312993overpert_
overplots1436953overplots
overplus1336063over_plus
overreacts1545433overreacts
overrules12129093overrules
oversales12313143oversales
oversalt11312743oversalt_
overseas112612423overse_as
overseeds13248893overseeds
overseers12298783overseers
oversees112415903overse_es
oversell1137473oversel_l
overset102821473overse_t_
oversews14289423overse_ws
overshots1546623overshots
overtalks1645663overtalks
overtreats1346643overtreats
overwears15227873overwears
overweens15247003overweens
overwet132013933overwe_t_
overwhelms2142133overwhelms
overzeals2165763overzeals
remelts93511493_re_melts
resmelts1046143_resmelts
thermels13607763thermel_s
varments1339063_varments
vermeils1374813_vermeils
vermes115019143_verme__s
versets103913103_verse_ts
vervets13419753_verve_ts
wergelts1253413_wergelts

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 Filter1786911486410.420425454.8
2DLD Change Limit148641947.56319653.7
3Display Results94940.0462043.5
 (SQL Overall)178691948.02922255.7
 
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.