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

104 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
overcram153707(None) 
overcrams1646411overcrams
overarm12239792overar_m
overcame151310692overc_ame
overclaim1645332overclaim
overcoat13312102overcoat
overcrop1545772overcrop
overdraw1535802overdraw
overran10311662over_ran
overtrim1337482overtrim
overwarm16236932overwarm
hovercraft2152703hovercraft
novercal1345683noverc_al
overarch1647243overarch
overarms13258383overarms
overbear13228883overbear
overbeat132713833overbeat
overbrake1847253overbrake
overbred1459853overbred
overbroad1545433overbroad
overcall1337673overcall
overcast132411973overcast
overcheap1953513overcheap
overclaims1744683overclaims
overclass1436963overclass
overclean14115263overclean
overclear14134743overclear
overcoach1944793overcoach
overcoats1438863overcoats
overcold14208493overcold
overcome151110703overcome
overcook1786153overcook
overcool1376783overcool
overcoy1536633overc_oy
overcrammed2143943overcrammed
overcrops1646543overcrops
overcrowd1844583overcrowd
overcure132210053overcure
overcured15148643overcured
overcures14139993overcures
overcut12310423overc_ut
overcuts1337513overcuts
overdare12311183overdare
overdear12248083overdear
overdraft1646713overdraft
overdrank1745123overdrank
overdrawn1644673overdrawn
overdraws1645663overdraws
overdrew1536233overdrew
overdry1435903overdr_y
overeat102620323over_eat
overfar13227943over_far
overfat132712283over_fat
overfear14247403overfear
overfrank1944573overfrank
overfree1439003overfree
overglad13116533overglad
overgoad13127153overgoad
overgrade1457623overgrade
overgraze2276673overgraze
overgreat1347713overgreat
overgrew1535823overgrew
overgrow1544833overgrow
overhard15238793overhard
overhead152110363overhead
overheap16257343overheap
overhear14249413overhear
overheat142413773overheat
overlap12239833over_lap
overlax17238413over_lax
overlay132410833over_lay
overleaf14237973overleaf
overleap13237833overleap
overload12119283overload
overman12311463over_man
overnear11238473overnear
overneat112713643overneat
overpay15228263over_pay
overplan13258943overplan
overplay16257553overplay
overrank1548113over_rank
overrash1436953over_rash
overrate11615693over_rate
overrun1038023over_run
oversad11259963over_sad
oversaw13268163over_saw
oversea102412113oversea_
overseas112612423overseas
oversoak1536993oversoak
overstay1436733overstay
overtame131510523over_tame
overtart11312493overtart
overtax17257733over_tax
overtrade1348513overtrade
overtrain1259783overtrain
overtreat1249373overtreat
overtrims1447503overtrims
overtrump1643563overtrump
overurge1277103overurge
overwarms17225693overwarms
overwary17197413overwary
overweak18216073overweak
overwear14248603overwear
overzeal2076093overzeal

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621046.91021152.2
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.37624226.0
 
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.