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

108 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
corvette133809(None) 
corvettes1447431corvettes
coquette1976592coquette
corvee114320092corve__e
corvet114626932corve_t_
corvets124715022corve_ts
courgette1244522courgette
curette939782cur_ette
curvetted1543702curvetted
cuvette1235832c_uvette
ariette7312373_ariette
barbette1249113barbette
barrette1039783barrette
burette939853bur_ette
casette9310393c_asette
cassette1047813cassette
cavetti1245413c_avetti
cavetto1245453c_avetto
cleveite1343823cleveite
cocotte1138603co_cotte
cocreate122611813cocreate
compete134716553compe_te
confetti1345983confetti
confetto1346253confetto
convect143114483convect_
convected1738783convected
convects153410993convects
convene123314323conve_ne
convent123919413convent_
convented15410753convented
convents132614603convents
converge1437383converge
converse13310263converse
convert123721473convert_
converted15311563converted
converter14311013converter
converts133213553converts
coquetted2154823coquetted
coquettes2065983coquettes
cordate10315213cor_date
cordelle1148433cordelle
cordite10315253cor_dite
corelate10516013corelate
cornet84436733corne_t_
cornetcy1544303cornetcy
cornets94820573corne_ts
cornute939633cor_nute
coronate103018213coronate
corotate102813933corotate
correct11513983correct_
corrected1438113corrected
correcter1348103correcter
corrects1259573corrects
correlate1149043correlate
corselet10414573corselet
corselette1253483corselette
corset85636223corse_t_
corseted11311473corseted
corsetry1365563corsetry
corsets94819803corse_ts
cortege1098943corte_ge
corvees124613793corve_es
corves115122523corve__s
corvine122113643corv_ine
couchette1644913couchette
courgettes1344123courgettes
covert114925503co_vert_
coverts124813813co_verts
covet105638943co_ve_t_
coveted133011523co_veted
coveter122912063co_veter
covets114819643co_ve_ts
create85126373c_r_eate
croquette2043653croquette
curetted1137173cur_etted
curettes1039313cur_ettes
curvet114720243curve_t_
curveted1435293curveted
curvets12399913curve_ts
cuvettes1335323c_uvettes
forgetter1345373forgetter
fossette1145263fossette
fouette1038213fo_uette
foveate1338363fo_veate
georgette1182373georgette
jockette2165033jockette
lorgnette1043113lorgnette
mofette1296773mo_fette
moffette1643493moffette
moquette1944973moquette
mozette1886773mo_zette
mozzette1842903mozzette
navette1036983_navette
noisette846313noisette
ocreate93711743ocr_eate
octette946423_octette
parkette14138023parkette
proette9312363_proette
roomette1046103roomette
roquette1755533roquette
rosette7310373ro_sette
roulette847093roulette
serviette1242963serviette
sirvente1145023sirvente
strette7310763str_ette
syrette1037183syr_ette
toilette846683toilette
tonette7310373to_nette

Search took 10 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.1731032896.0
2DLD Change Limit1461621088.84316528.6
3Display Results1081080.0801350.0
 (SQL Overall)1786911089.09619645.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.