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

305 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
thecae1129965(None) 
theca103311451theca_
thecal113310301thecal
thecate123210021thecate
chelae113614602chelae
oothecae1343712oothecae
telae54323292t_elae
thae76825562th__ae
thebe107515432the_be
thee78039062the__e
theine94814922theine
theme105921732the_me
thenage11107832thenage
thenal92712412thenal
thenar9269992thenar
thence112010842thence
there87527392the_re
thermae125310492thermae
therme115814992therme
these86519012the_se
theta83414572theta_
thetas93011572thetas
toecap1037322toecap
ahead96817053ahe_ad
amebae1049633amebae
areae55229743are_ae
areca75618633areca_
arecas84817443arecas
baccae12119703baccae
became123213163_became
becap114315053_becap
caeca93915133caeca_
caecal103713733caecal
ceca84820783_ceca_
cecal94619113_cecal
chaetae1238603chaetae
cheap126915943che_ap
cheat105732453che_at
check164714713chec_k
checked193710023checked
checker18329533checker
checks174912703checks
cheese113812763cheese
chegoe1237273chegoe
chela103916803chela_
chelas113817203chelas
chelate122914893chelate
cheque2036663cheque
chetah14399583chetah
chevre14318313chevre
chica125818263chica_
chicane1489553chicane
chicas135916463chicas
chicle134312543chicle
creche13310763creche
decade104216163_decade
decaf114919443_decaf
decal85523233_decal
decane93818873_decane
decare93919153_decare
decay114718483_decay
eche97520283__eche
ethene93312923ethe_ne
ethical1238443ethical
faecal11359813faecal
fecal105119213_fecal
fleche14299303fleche
ghee85726113ghe__e
gherao1036753gherao
glebae9407613glebae
hae67364003_h__ae
head87137173_he_ad
heal75645693_he_al
heap96432893_he_ap
hear76143883_he_ar
heat77061423_he_at
heave114521813_heave
hebe96424703_he_be
heck135826493_hec_k
heckle153112093_heckle
hecks145220653_hecks
hectare1238463_hectare
hedge105317333_hedge
heeze175313483_heeze
helve115018093_helve
hemal104419803_hemal
heme95034413_he_me
hence104920043_hence
henge94819823_henge
hepcat13611823_hepcat
here76447103_he_re
hermae115314473_hermae
hexad164910623_hexad
hexade17438903_hexade
hexane16379533_hexane
hoecake1645203hoecake
icecap1245223icecap
ipecac1264623ipecac
kheda1346533kheda_
khedah1743643khedah
khedas1446313khedas
muscae10410673muscae
niece74814503niec_e
ootheca1244003ootheca_
oothecal1343913oothecal
peace95026083_peace
pecan91919033_pecan
phenate12412193phenate
phylae14458733phylae
piece96717993piec_e
plicae10410953plicae
recane83022873_recane
recap95718023_recap
recce9514563_recce
rhea75017433rhe_a_
rheas84816953rhe_as
rheme106214053rhe_me
setae56026223_setae
shea76031573she_a_
sheaf115424123she_af
sheal84927703she_al
shear85424833she_ar
sheas86331793she_as
sheave124514003sheave
sheeve123412843sheeve
shelve124012763shelve
specie10412223specie
spicae104313703spicae
stelae63716483stelae
tace65342513t_ac_e
tache106222373t_ache
tae38267053t___ae
taeniae739083taeniae
tea37353323t_e_a_
teacake1335453teacake
teach105221123t_each
teak85930843t_e_ak
teal45546503t_e_al
team66238653t_e_am
tear45242883t_e_ar
teas45851493t_e_as
tease55428713t_ease
teat45963633t_e_at
tech95925443t_ec_h
teched124014433t_eched
techie11511723t_echie
techs106915833t_echs
techy135612013t_echy
tecta74215523t_ecta
tectal83713253t_ectal
tee38366873t_e__e
teenage8108053teenage
teepee8314363teepee
teethe94511313teethe
tela45532973t_ela_
tele45040873t_e_le
tenace82715693t_enace
tenge65720433t_enge
teniae64517353teniae
tense55225843t_ense
tepa66021683t_epa_
tepal76319583t_epal
tepas76521683t_epas
tepee74724213t_epee
terai53525483t_erai
terce75721843t_erce
terne56426153t_erne
terrae62915203terrae
terse55026823t_erse
testae64216253testae
texas126514933t_exas
thack144915173thac_k
thacked173810203thacked
thacks154311923thacks
than76128773th__an
thanage11117933thanage
thane86122533th_ane
that75639323th__at
thaw107521313th__aw
the67436053th___e
theater104014253theater
theatre10358493theatre
thebaine1355423thebaine
thebes115914493thebes
theft114118133the_ft
thefts12387923thefts
thegn95810903the_gn
thegns10547433thegns
thein85919023the_in
theines104013233theines
theins95015423theins
their85512153the_ir
theirs94610353theirs
theism1139483theism
theist9314763theist
them97427043the__m
themed125912583themed
themes115319253themes
then78429693the__n
thenages12107473thenages
thenars10248503thenars
thens85921833the_ns
theocrat1346353theocrat
theorem1236263theorem
theory121098353theory
therapy1536613therapy
thereat104315243thereat
theres96525473theres
theriac1239143theriac
therian10311293therian
therm106018023the_rm
thermal125010963thermal
thermel12569893thermel
thermes126214613thermes
therms115914873therms
theses96517973theses
thesis94913733thesis
thesp105410313the_sp
thesps11448263thesps
thetic11412883thetic
thetical1349123thetical
thew108226233the__w
thewier1336063thewier
thews117416193the_ws
thewy146311853the_wy
they107223753the__y
thick145613353thic_k
thicken16317873thicken
thicker163611023thicker
thicket163213073thicket
thicks154511993thicks
thieve1235963thieve
thine85026853th_ine
thiram1139943thiram
thole85620843th_ole
thorax1638253thorax
thorpe113610093thorpe
those85218143th_ose
thrave126010273thrave
thraw1110515923th_raw
thread105011093thread
threap11569663threap
threat95020463threat
three87526913th_ree
thrice114311573thrice
thrive125313223thrive
throat94819753throat
throe89321423th_roe
throne98517603throne
throve128012393throve
thuja1535213thuja_
thujas1634433thujas
thuya1135583thuya_
thuyas1234773thuyas
thwack1834213thwack
thyme134612473th_yme
thyrse1235133thyrse
tibiae838473tibiae
tical76021493t_ical
tierce8339843tierce
tincal83913353tincal
tipcat10312653tipcat
toccate1138773toccate
toea46732333toe_a_
toeas55726423toe_as
toecaps1135553toecaps
togae67020113t_ogae
tomcat101013453tomcat
toucan838193toucan
touche114916173touche
trace75829613trac_e
treacle939973treacle
tread64821703tre_ad
treat56240353tre_at
treble8311663treble
tree47745813tre__e
trefah1235093trefah
trepan82511673trepan
trice75127493tric_e
trocar848763trocar
troche113112513troche
truce75118693truc_e
tsetse664693tsetse
tubae74716643t_ubae
tunicae9328143tunicae
tusche1136783tusche
twae74719573t__wae
tweak1257753twe_ak
twee76827083twe__e
tweeze18265473tweeze
twelve1234163twelve
twice104711123twic_e
tyee75131423tye__e
typecase1543463typecase
tzetze1432733tzetze
venae85920983_venae
wheal115716183whe_al
wheat114924573whe_at
whee105429593whe__e
wheeze21276813wheeze
whenas124610463whenas
whence14187923whence
where117019423whe_re
wherve15568113wherve
zoeae144412483zoe_ae

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163057.08015920.3
3Display Results3053050.1861639.8
 (SQL Overall)1786913057.40624127.9
 
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.