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

311 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
thyrse123513(None) 
thyrses1335021thyrses
thyrsi1234451thyrsi
ahorse9311512ahorse
horse86132652_horse
terse55026822t_erse
there87527392ther_e
theres96525472theres
therme115814992therme
these86519012th_ese
thirst9312252thirst
thorpe113610092thorpe
those85218142th_ose
three87526912th_ree
throe89321422th_roe
thyme134612472thy_me
thymes144810742thymes
thyrsus1342692thyrsus
torse55833332t_orse
tyre75428252t_yr_e
tyres84725232t_yres
apyrase1236363apyrase
arse46539273__arse
athirst1037873athirst
averse95811183averse
birse74517403_birse
bourse84414333bourse
burse75527253_burse
byre95023853_byr_e
byres104421383_byres
carse74934333_carse
cayuse11207763cayuse
chaise114916413chaise
chare105231983char_e
chares115631803chares
charge125114213charge
chars105936643chars_
chase105127123ch_ase
chasse115114603chasse
cheese113812763cheese
chirre114111853chirre
choose115116143choose
chore105126763chor_e
chores114828023chores
chose105925403ch_ose
chouse116017563chouse
chowse144711753chowse
chyle134913483chy_le
chyles144813283chyles
chyme156512503chy_me
chymes165912153chymes
coarse84813903coarse
corse75036183_corse
course85117783course
curse75829143_curse
ethers94518413ethers_
ethyls1235903ethyls_
ethyne12407153ethy_ne
ethynes13377573ethynes
eyre75525253_eyr_e
eyres84921773_eyres
eyrie88117833_eyrie
gorse65926813_gorse
gyrase10508773_gyrase
gyre84722763_gyr_e
gyres94820323_gyres
gyrose105310253_gyrose
hanse85722793_hanse
hare76255733_har_e
hares86255543_hares
harsh116418053_harsh
hawse116015123_hawse
hearse94114273hearse
here76447103_her_e
heres86245903_heres
hers75844873_hers_
hire75538963_hir_e
hiree85427803_hiree
hires86134343_hires
hirsel9138683_hirsel
hirsle9159573_hirsle
hoarse94411323hoarse
hoise85224773_hoise
horde94623053_horde
horsed105321083_horsed
horses94729343_horses
horsey125115403_horsey
horst85833513_horst
horste94817413_horste
horsy116318393_horsy
hose76547243_h_ose
house89131423_house
hurst85527193_hurst
hydrae13258573_hydrae
hydrase14287663_hydrase
hype125519813_hy_pe
hypes135818673_hypes
hyps125418413_hyps_
hyrax1838033_hyrax
hyte109018943_hy_te
kyrie123712903_kyrie
lyase85512413_lyase
lyre75623793_lyr_e
lyres85019963_lyres
lyse76320593_ly_se
marse76231153_marse
morse76032703_morse
nurse54420123_nurse
others93918003others_
parse75236993_parse
perse75429523_perse
phase104617213ph_ase
phrase11109903phrase
phylae14458733phylae
phyle134111153phy_le
physed15386793phy_sed
physes14399783phy_ses
purse76028893_purse
pyre94925553_pyr_e
pyres105523883_pyres
rhyme13479553rhy_me
rhymes14419823rhymes
share86437083shar_e
shares95236413shares
shikse1386073shikse
shire84727133shir_e
shires95225573shires
shore85432653shor_e
shores94830413shores
shyers124712203shyers_
shyest125511833shyest
sparse84516343sparse
tahrs85412333tahrs_
tare45957623t_ar_e
tares57456563t_ares
targe65227093t_arge
tarre55825633t_arre
tarres64723043tarres
tars46763953t_ars_
tarsi55222173t_arsi
tasse54821843t_asse
tawse85616503t_awse
tears55436463tears_
tease55428713t_ease
tense55225843t_ense
terce75721843t_erce
terne56426153t_erne
terrae62915213terrae
terser67317823t_erser
thae76825563th__ae
thane86122533th_ane
thanes94918983thanes
tharm105916643thar_m
tharms115712243tharms
thaws116515463thaws_
the67436053th___e
thebe107515433th_ebe
thebes115914493thebes
thecae11299653thecae
thee78039063th__ee
theine94814923theine
theirs94610353theirs_
theism1139483theism
theist9314763theist
theme105921733th_eme
themes115319253themes
thence112010843thence
thens85921833thens_
theorise1137873theorise
therm106018023ther_m
thermae125310503thermae
thermel12569893thermel
thermes126214613thermes
therms115914873therms
theses96517973th_eses
thesp105410313th_esp
thews117416193thews_
thieve1235963thieve
thine85026863th_ine
thins85826333thins_
thir76420543thir__
thiram1139963thiram
third95912493thir_d
thirds10438603thirds
thirl85416823thir_l
thirled11328093thirled
thirls95012063thirls
thirsted1235213thirsted
thirster1135673thirster
thirsts1036243thirsts
thirsty1354083thirsty
thirty12378403thirty
this76027383th_is_
thole85620843th_ole
tholes94919783tholes
thorax1638253thorax
thoria93012893thoria
thoric114314043thoric
thorite10313443thorite
thorn85318703thor_n
thorned11479403thorned
thorns95314103thorns
thorny12509843thorny
thoro86217873thor_o
thoron94713903thoron
thorp104414263thor_p
thorpes125010353thorpes
thorps113610893thorps
thous86017263thous_
thrash12258363thrash
thrave126010273thrave
thraw1110515923th_raw
threep115910113th_reep
threes97117323th_rees
thresh12276863thresh
threw1117315713th_rew
thrice114311573thrice
thrip103012183th_rip
thrive125313223thrive
thro77726423th_r_o
throb109816853th_rob
throes97518673th_roes
throne98517603throne
throve128012393throve
throw118719733th_row
thru76818943th_r_u
thrum104713633th_rum
thrush12257483thrush
thrust91911893thrust
thuds95110133thuds_
thugs95611993thugs_
thurl84912683thur_l
thurls9418713thurls
thus76721473th_us_
thuyas1234773thuyas_
thy97022913thy___
thymey17426313thymey
thymi13418633thy_mi
thymic16307423thymic
thymier1534393thymier
thymine1536643thymine
thymol1434463thymol
thymus14324743thymus
thymuses1643073thymuses
thymy16437923thy_my
thyroid1438253thyroid
thyrsoid1544193thyrsoid
thyself1643033thy_self
tierce8339843tierce
tiers55526523tiers_
tire46143353t_ir_e
tires55437493t_ires
titre54619393titr_e
titres64718933titres
tore47359323t_or_e
tores55352673t_ores
torose64317693torose
torrs53923563torrs_
tors46157383t_ors_
torses64727953t_orses
torsi57423363t_orsi
torsk94915773t_orsk
torso56922143t_orso
torte55431703t_orte
tours55325893tours_
touse55430673t_ouse
toyers95516333toyers_
toyish122911123toyish
toyos87519143toyos_
toys78036343toy_s_
tree47745813t__ree
tres46542903t__res
triose64715383triose
true46725853t__rue
tryst84716223try_st
tryste9399583tryste
tsars56717113tsars_
tsetse664693tsetse
tsores65113663tsores
tuyere9408613tuyere
tuyeres10417793tuyeres
tuyers94612563tuyers_
twyers12497413twyers_
tye65837443t_y__e
tyee75131423t_y_ee
tyees86019453t_yees
tyers86220053tyers_
tyes76433373t_yes_
tyke115720503t_y_ke
tykes125817063t_ykes
tyne76325053t_y_ne
tynes85920303t_ynes
type96223743t_y_pe
types105721063t_ypes
tyred95816433t_yred
tyro76622363t_yr_o
tyros85118593t_yros
tythe115210453t_ythe
tzars144914273tzars_
unhorse1038583unhorse
verse84723583_verse
wharve15456203wharve
where117019423wher_e
wheres125917433wheres
wherve15568113wherve
whirs115218093whirs_
whore116018043whor_e
whores125617103whores
whose114914533wh_ose
whys137011663why_s_
worse86525263_worse

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.376475242.0
2DLD Change Limit1127163114.61024450.3
3Display Results3113110.0933344.1
 (SQL Overall)1786913115.07935182.3
 
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.