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

151 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
thyrsi123445(None) 
thyrse1235131thyrse
tarsi55222172t_arsi
thirst9312252thirst
thymi13418632thy_mi
thyroid1438252thyroid
thyrses1335022thyrses
thyrsoid1544192thyrsoid
thyrsus1342692thyrsus
torsi57423362t_orsi
ahorse9311513ahorse
athirst1037873athirst
byssi10507993_byssi
chars105936643chars_
ethers94518413ethers_
ethyls1235903ethyls_
gharri10386163gharri
gyri85415153_gyr_i
harsh116418053_harsh
hers75844873_hers_
horse86132653_horse
horst85833513_horst
horsy116318393_horsy
hurst85527193_hurst
hybris14247003_hybris
hyps125418413_hyps_
hyrax1838033_hyrax
others93918003others_
physic16288473phy_sic
physis14359663phy_sis
shri76021703sh_r_i
shris84221453sh_ris
shyers124712203shyers_
shyest125511833shyest
tahrs85412333tahrs_
tars46763953t_ars_
tarsia65514273t_arsia
tears55436463tears_
terai53525483t_erai
terse55026823t_erse
tetri52716453tetr_i
tetris62816293tetris
thalli958923thalli
tharm105916643thar_m
tharms115712243tharms
thaws116515463thaws_
theirs94610353theirs_
theism1139483theism
theist9314763theist
thens85921833thens_
there87527393ther_e
therein102310353therein
theres96525473theres
therm106018023ther_m
therme115814993therme
thermic1439333thermic
thermit12312013thermit
therms115914873therms
theroid11313403theroid
these86519013th_ese
thesis94913733th_esis
thesp105410313th_esp
thews117416193thews_
thins85826333thins_
thir76420543thir__
thiram1139963thiram
third95912493thir_d
thirds10438603thirds
thirl85416823thir_l
thirls95012063thirls
thirsts1036243thirsts
thirsty1354083thirsty
thirty12378403thirty
this76027383th_is_
tholoi9339233tholoi
thorax1638253thorax
thoria93012893thoria
thoric114314043thoric
thorn85318703thor_n
thorns95314103thorns
thorny12509843thorny
thoro86217873thor_o
thoron94713903thoron
thorp104414263thor_p
thorpe113610093thorpe
thorps113610893thorps
those85218143th_ose
thous86017263thous_
thrash12258363thrash
thraw1110515923th_raw
three87526913th_ree
thresh12276863thresh
threw1117315713th_rew
thrip103012183th_rip
thro77726423th_r_o
throb109816853th_rob
throe89321423th_roe
throw118719733th_row
thru76818943th_r_u
thrum104713633th_rum
thrush12257483thrush
thrust91911893thrust
thuds95110133thuds_
thugs95611993thugs_
thurl84912683thur_l
thurls9418713thurls
thus76721473th_us_
thuyas1234773thuyas_
thy97022913thy___
thyme134612473thy_me
thymes144810743thymes
thymey17426313thymey
thymic16307423thymic
thymol1434463thymol
thymosin1644493thymosin
thymus14324743thymus
thymy16437923thy_my
thyreoid1544773thyreoid
thyroids1546003thyroids
thyroxin2144183thyroxin
tiers55526523tiers_
tori47542153t_or_i
torii55521593t_orii
torrs53923563torrs_
tors46157383t_ors_
torse55833333t_orse
torsk94915773t_orsk
torso56922143t_orso
tours55325893tours_
toyers95516333toyers_
toyish122911123toyish
toyos87519143toyos_
toys78036343toy_s_
trypsin1245113trypsin
tryst84716223try_st
tsars56717113tsars_
tsoris63411193tsoris
tsuris62710203tsuris
tuyers94612563tuyers_
twyers12497413twyers_
tyers86220053tyers_
tyes76433373t_yes_
tyre75428253t_yr_e
tyred95816433t_yred
tyres84725233t_yres
tyro76622363t_yr_o
tyros85118593t_yros
tzars144914273tzars_
tzuris15286913tzuris
whirs115218093whirs_
whys137011663why_s_

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 Limit1127161514.59324540.8
3Display Results1511510.0463282.6
 (SQL Overall)1786911515.01535631.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.