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

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

86 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
overed10221662(None) 
covered133315291covered
hovered143411571hovered
overbed132811851overbed
overfed142510251overfed
averred11237592averred
averted112211612averted
bowered133113042bowered
cered85227442_cered
clovered14187362clovered
cohered133514692cohered
coverer123113522coverer
coveted133011522coveted
cowered133214652cowered
dovened12389062dovened
dowered122811552dowered
evened101010312evened
everted112711852everted
fevered14339722fevered
governed1335192governed
havered144011452havered
homered133212712homered
hoovered15195412hoovered
hoveled14209292hoveled
hoverer13319822hoverer
jeered143912792jeered
leered73816222leered
levered114212302levered
livered113111632livered
louvered1244992louvered
lowered112711912lowered
oared65030652o_ared
obeyed1235822obeyed
obverted1435102obverted
ochered132610282ochered
ochred12328002ochred
odored8399222odored
offered1436142offered
omened93711002omened
opened94311862opened
ordered9108532ordered
osiered837122osiered
over77227342over__
overaged13511672overaged
overawed1579972overawed
overbet122716062overbet
overbid132710272overbid
overbred1459852overbred
overdid12199172overdid
overdo10128362overdo
overdyed16126512overdyed
overeat102620322overeat
overedit1249162overedit
overfeed15299442overfeed
overhead152110362overhead
overheld15197372overheld
overlend122510102overlend
overlet102619032overlet
overlewd15216272overlewd
overly122411362overly
overmen12311802overmen
overnew13268132overnew
overs85224792over_s
oversad11259962oversad
oversea102412112oversea
oversee102717602oversee
overseed122513352overseed
overset102821472overset
oversew132810832oversew
overt85630722over_t
overused1249442overused
overwet132013932overwet
peered93819492peered
powered132911642powered
revered112819332revered
rogered939552rogered
sered65737292_sered
severed113513862severed
sobered102912432sobered
tiered73613972tiered
towered112911402towered
veered103612742veered
verged114815162_verged
versed104515512_versed
vexed165713112_vexed
wavered142910432wavered

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit82551862.15338342.3
3Display Results86860.0332606.1
 (SQL Overall)178691862.53270573.1
 
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.