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

119 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
ectype133428(None) 
ecotype1444841ecotype
ectypes1434801ectypes
cotype1346822cotype
ecotypes1545052ecotypes
ectypal1442772ectypal
etape74413702e_tape
neotype1244592neotype
retype11399142retype
type96223742__type
active11313743active
biotype1444423biotype
blype12429673_blype
cape87242783_c_ape
cepe84926653_c_epe
cerotype1544653cerotype
cetane8315283cetane
cete64934783cet__e
chape125221143_chape
chyle134913483_chyle
chyme156512503_chyme
clepe94617383_clepe
clypei1334163_clypei
cope86847383_c_ope
cotypes1437943cotypes
coupe96023483_coupe
coypu12349873_coypu
crape96128443_crape
crepe95520723_crepe
cripe95521143_cripe
crypt123715233_crypt
cyme119420373_c_yme
decrypt1545703decrypt
ecarte84313503ecarte
ecdyses1333413ecdyses
eche97520283ec__he
eclipse1144183eclipse
ecotage1036883ecotage
ecotone938583ecotone
ecotypic1744413ecotypic
ectases92911673ectases
ecthyma1752613ecthyma
ectopia1147693ectopia
ectopic1338153ectopic
elope75219343e_lope
emyde1136383e_myde
encrypt1445323encrypt
entice81316863entice
entire61617703entire
entree61817883entree
enzyme2054343enzyme
epitope1147053epitope
escape103811663escape
estate64719763estate
estop74312103estop_
estops84011223estops
etapes85415293e_tapes
ethyne12407153ethyne
etude63612303e_tude
etwee84115333e_twee
etyma1036583e_tyma
eye65539773e__y_e
eyne76322463e__yne
eyre75525253e__yre
genotype1444483genotype
hectare1238463hectare
hype125519813__hype
isotype12224953isotype
lectotype1653453lectotype
lecture9149513lecture
metope10611123metope
mistype14126523mistype
neotypes1344523neotypes
octane81411633octane
octave11157343octave
octopi1036533octopi
octuple1153993octuple
octyl10136063octy_l
octyls11135323octyls
pectase112410363pectase
pectate112214693pectate
pectize20259913pectize
pretype14387483pretype
recipe103414893rec_ipe
recoupe11109933recoupe
restyle1038763restyle
retape83917683retape
retyped13367303retyped
retypes12308623retypes
scape96921843sc_ape
scope94821483sc_ope
scrape105917573scrape
scythe14466013scythe
sectile9311973sectile
serotype1345163serotype
slype105112363_slype
stipe76523373_stipe
stope74727243_stope
stupe75217753_stupe
stye76218973_sty_e
style85519363_style
subtype1444203subtype
tape64538143__tape
tectite9310583tectite
teletype1394543teletype
tintype1243033tintype
tope65946383__tope
tye65837443__ty_e
tyee75131423__tyee
tyke115720503__tyke
tyne76325053__tyne
typed115815453__typed
types105721063__types
typey135511883__typey
typo95418123__typo
typp115812783__typp
typy126013043__typy
tyre75428253__tyre
watape11208483watape

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127161194.76323664.9
3Display Results1191190.0502380.0
 (SQL Overall)1786911195.20634324.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.