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

143 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
coverlet1341301(None) 
coverlets1437051coverlets
overlet102619031_overlet
covered133315292cover_ed
coverer123113522cover_er
coverless1436802coverless
coverlid1445942coverlid
covert114925502cover__t
foveolet14107542foveolet
overbet122716062_overbet
overlent112715292_overlent
overlets112312362_overlets
overlit102714742_overlit
overset102821472_overset
overwet132013932_overwet
cabernet12410763cabernet
capelet11517073cape_let
caverned1436163caverned
cermet10321153c__ermet
cheerled14105703cheerled
chevalet1658123chevalet
chevret153310633chevr_et
clovered14187363clover_ed
cloverleaf1851223cloverleaf
coerce10310403co_erce_
coerced1238583co_erced
coercer1138383co_ercer
coerces11311943co_erces
coerect11913353co_erect
coffret15310073coffr_et
cohere112716993coher_e_
cohered133514693coher_ed
coherent13412473coherent
coherer122912783coher_er
coheres122917693coher_es
collet84030363co__llet
converge1437383converge_
converged1636963converged
convergent1648033convergent
converges1538373converges
converse13310263converse_
conversed1538683conversed
converser1438093converser
converses14311163converses
convert123721473conver__t
converted15311563converted
converter14311013converter
cornet84436733co__rnet
corselet10414573corselet
corset85636223co__rset
corslet9318063co_rslet
corvet114626933co__rvet
coterie9417403coterie_
coteries10422703coteries
couplet114717943co_uplet
covalent1349223cov_alent
covaried1448003covaried
covaries13413253covaries
covellite1445603covellite
covenant1349693covenant
cover105430773cover___
coverable1649103coverable_
coverage1438733coverage
coverages1538833coverages
coverall1347603coverall
coveralled1644183coveralled
coveralls1447083coveralls
coverers132712123coverers
covering142215723covering
coverlids1544753coverlids
covers114627963cover__s
coverslip1643273coverslip
covertly1655763covertly
coverts124813813cover_ts
coverup1434623cover_up
coverups1544063coverups
covet105638943cov___et
coveted133011523cove_ted
coveter122912063cove_ter
cowered133214643cower_ed
craterlet1148413craterlet
foveole13106873foveole_
foveoles1496643foveoles
foveolets15103233foveolets
governed1335193governed
hoveled14209293hove_led
hovelled15146843hovelled
hovered143411573hover_ed
hoverer13319823hover_er
leveret103014003lever_et
loverly1346973loverl_y
novelle1058233novelle_
omelet8317073_ome_let
overact12315043_overact
overalert12411113_overalert
overapt12312653_overapt
overate10620963_overate
overbeat132713833_overbeat
overbed132811853_overbed
overbets132510683_overbets
overblew1636223_overblew
overcut12310423_overcut
overeat102620323_overeat
overed102216623_over_ed
overfat132712283_overfat
overfed142510253_overfed
overfit132610963_overfit
overflew1735593_overflew
overheat142413773_overheat
overhot13411223_overhot
overlap12239833_overlap
overlate11716283_overlate
overlax17238413_overlax
overlay132410833_overlay
overleaf14237973_overleaf
overleap13237833_overleap
overleapt14247883_overleapt
overlend122510103_overlend
overlewd15216273_overlewd
overlie102615013_overlie
overlies112417043_overlies
overly122411363_overl_y
overmelt13310713_overmelt
overmen12311803_overmen
overneat112713643_overneat
overnew13268133_overnew
overpert13312993_overpert
overplot1338543_overplot
oversea102412113_oversea
oversee102717603_oversee
oversets113114173_oversets
oversew132810833_oversew
overslept1446853_overslept
overt85630723_over__t
overwets14219953_overwets
soleret7321233soler_et
somerset10411073somerset
sterlet71318473_sterlet
underlet91516213underlet
varlet9423503__varlet
verset94327323__verset
vervet124619063__vervet
wavelet13310943wave_let

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.1531167915.0
2DLD Change Limit1461621437.12620511.1
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.32524394.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.