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

258 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
thyrses133501(None) 
thyrse1235131thyrse_
thyrsus1342681thyrsus
horses94729342_horses
physes14399782phy_ses
theres96525472ther_es
thermes126214612thermes
theses96517972th_eses
thirsts1036242thirsts
thorpes125010352thorpes
threes97117322th_rees
throes97518672th_roes
thymes144810742thy_mes
thymuses1643072thymuses
thyrsi1234452thyrs_i
torses64727952t_orses
tyres84725232t_yr_es
abysses1234863abysses
ahorse9311513ahorse_
apyrases1337243apyrases
arses55733873__arses
birses84717733_birses
bourses94014303bourses
burses84425513_burses
byres104421383_byr_es
carses85233653_carses
catharses1446403catharses
cayuses12188403cayuses
chaises124317493chaises
chaoses124715113chaoses
charases131312753charases
chares115631803char_es
charges134615983charges
chases115128233ch_ases
chasses124017503chasses
cheeses123613103cheeses
chesses124112633chesses
chirres123812253chirres
chooses125717413chooses
chores114828023chor_es
choruses1339983choruses
choses115825123ch_oses
chouses125117813chouses
chowses155611283chowses
chyles144813283chy_les
chymes165912153chy_mes
corses84433463_corses
courses94218893courses
curses85328273_curses
cyeses11510123_cyeses
erses55826803__erses
ethnoses1146073ethnoses
ethoses10311753eth_oses
ethynes13377573ethy_nes
eyases94513683_eyases
eyres84921773_eyr_es
eyries93816813_eyries
gorses74723293_gorses
gyrases11368313_gyrases
gyres94820323_gyr_es
hanses95022633_hanses
hares86255543_har_es
hawses125113993_hawses
hearses104414533hearses
heres86245903_her_es
heroes94923823_heroes
herpes115517323_herpes
hirees95117293_hirees
hires86134343_hir_es
hirsel9138683_hirsel
hirsels10128343_hirsels
hirsles101510073_hirsles
hisses94719353_hisses
hoises94823673_hoises
hordes104921633_hordes
horse86132653_horse_
horsed105321083_horsed
horsey125115403_horsey
horstes104516113_horstes
horsts95817513_horsts
hoses85443173_h_oses
houses96032273_houses
hursts97213093_hursts
hybrises1645423_hybrises
hydrases15227643_hydrases
hypes135818673_hy_pes
hyraces1537913_hyraces
hyraxes2045703_hyraxes
katharses1643873katharses
kyries133411373_kyries
lyases95211873_lyases
lyres85019963_lyr_es
lyses84518253_ly_ses
marses84827113_marses
myases113711553_myases
myoses114013843_myoses
nurses63919353_nurses
parses85534703_parses
perses85428063_perses
pharoses13310313pharoses
phases114618403ph_ases
phereses1348093phereses
phrases12711463phrases
phyleses1645183phyleses
physed15386793phy_sed
physeds16344033phy_seds
physis14359663phy_sis
purses84826373_purses
pyoses114314303_pyoses
pyres105523883_pyr_es
rhuses94911793rh_uses
rhymes14419823rhy_mes
shares95236413shar_es
shikses14116573shikses
shires95225573shir_es
shores94830403shor_es
shyness1344993shyness
taluses7311213taluses
tamises92715973tamises
tapises92914013tapises
tares57456563t_ar_es
targes74524593t_arges
tarres64723043t_arres
tarries73324263tarries
tarsus6310513t_arsus
tasses64826763t_asses
tawses94913193t_awses
teases65426273t_eases
teleses7313123teleses
tenses64722553t_enses
terces83921413t_erces
ternes65422903t_ernes
terrases82111453terrases
terries73425613terries
terse55026823t_erse_
terser67317823t_erser
tersest71713993t_ersest
texases1437573texases
thanes94918983th_anes
tharms115712243thar_ms
thebes115914493th_ebes
theines104013233theines
theisms1237763theisms
theists1039143theists
themes115319253th_emes
theories11311593theories
theorises1247813theorises
there87527393ther_e_
therme115814993therme_
thermel12569893thermel
thermels13607763thermels
thermos124610753thermos
thermoses1447973thermoses
therms115914873ther_ms
these86519013th_ese_
thesis94913733th_esis
thesps11448263th_esps
thieves1346903thieves
thirams1236803thirams
thirds10438603thir_ds
thirled11328093thirled
thirls95012063thir_ls
thirst9312253thirs_t
thirsted1235213thirsted
thirster1135673thirster
thirsters1235223thirsters
thirsty1354083thirsty
thirties1139723thirties
tholes94919783th_oles
thoraces13118933thoraces
thoraxes1896353thoraxes
thorias102312043thorias
thorites11312393thorites
thorned11479403thorned
thorns95314093thor_ns
thorons104511913thorons
thorpe113610093thorpe_
thorps113610893thor_ps
those85218143th_ose_
thrashes1487653thrashes
thraves13469713thraves
thraws129211103th_raws
three87526913th_r_ee
threep115910113th_reep
threeps12687043th_reeps
thresh12276863th_resh
threshes1437383threshes
threw1117315713th_r_ew
thrips11299013th_rips
thrives134611713thrives
throbs118311373th_robs
throe89321423th_roe_
thrones105715843thrones
throws129715233th_rows
thrums11429123th_rums
thrushes1436523thrushes
thrusts10226523thrusts
thurls9418713thur_ls
thyme134612473thy_me_
thymey17426313thy_mey
thymier1534393thymier
thymiest1634733thymiest
thymines1635603thymines
thymols1533843thymols
thymus14324733thy_mus
thyroid1438243thyroid
thyroids1546003thyroids
thyrsoid1544183thyrsoid
thyself1643033thy_self
tierces93710453tierces
tigress836093tigress
tires55437493t_ir_es
titres64718933titr_es
tmeses85712243t_meses
tonuses73612193tonuses
tootses72910773tootses
tores55352673t_or_es
tories65435883t_ories
torse55833333t_orse_
torsks10549123t_orsks
torsos64815733t_orsos
tortes64826053t_ortes
tosses65225393t_osses
touses64229673t_ouses
toyless10268713toyless
trasses74819323trasses
trees55835763t__rees
tres46542903t__r_es
tress55423163t__ress
tresses73719543tresses
tries55742813t__ries
trioses75015653trioses
trues54925323t__rues
trusses73813633trusses
trystes10419993trystes
trysts9448793try_sts
tsetses785453tsetses
tsores65113663tsor_es
turves94212693t_urves
tusses64921243t_usses
tuyeres10417793tuyeres
tyees86019453t_y_ees
tyes76433373t_y__es
tykes125817063t_y_kes
tynes85920303t_y_nes
types105721063t_y_pes
tyre75428253t_yr_e_
tyred95816433t_yr_ed
tyros85118593t_yr_os
tythes12419703t_ythes
unhorses1138453unhorses
verses94223763_verses
wharves16457133wharves
wheres125917433wher_es
wherves16548053wherves
whores125617103whor_es
worses95522953_worses
yeses85119323__yeses

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272587.36018210.2
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.59323533.6
 
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.