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

183 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
thriven1344702(None) 
shriven13379651shriven
thrive125313221thrive_
thrived14458181thrived
thriver13479121thriver
thrives134611711thrives
driven105210142_driven
riven85121622__riven
shrive125216952shrive_
shrived144712182shrived
shrivel13479402shrivel
shriver134712192shriver
shrives134416172shrives
striven103910752striven
thrave126010272thrave_
thraves13469712thraves
thrice114311572thrice_
thrivers14456822thrivers
thriving15246352thriving
throve128012392throve_
trivet93721882t_rivet
arisen65316793_arisen
arrive91311793arrive_
arrived11127353arrived
arriver10117793arriver
arrives101311513arrives
carven114716663car_ven
chirren12388743chirren
chive135117623ch_ive_
chives144317593ch_ives
christen13106703christen
codriven1444393codriven
craven114113933_craven
derive103817043derive_
derived123912763derived
deriver114213913deriver
derives114017813derives
drive95318003_drive_
drivel105110383_drivel
driver104714493_driver
drives105117113_drives
enliven1034903enliven
forgiven1542983forgiven
given95915283__given
graven104513523_graven
grivet103517823_grivet
haven114718533_h_aven
heaven123912603_heaven
hive106029673_h_ive_
hived125217913_h_ived
hives116925513_h_ives
hoiden103612333_hoiden
liven85021733__liven
outdriven1344313outdriven
privet113821343_privet
proven114314773_proven
raven84723443__raven
redriven12226153redriven
regiven11478323regiven
rerisen73613643rerisen
ripen75619263__ripen
risen54621883__risen
rive75537723__rive_
rived94825613__rived
river85731693__river
rives85336003__rives
rivet85636363__rivet
roven85521973__roven
scrive115414943scrive_
scrived134511113scrived
scrives124414273scrives
shaven124213303sh_aven
shive114423423sh_ive_
shiver124517373sh_iver
shives124921413sh_ives
shriek134211103shri_ek
shrieve13417683shrieve
shrieved15276073shrieved
shrieves14297093shrieves
shrike134513243shrike_
shrikes144412393shrikes
shrine94920053shrine_
shrined114112413shrined
shrines104618693shrines
shrivels14376443shrivels
shrivers14419103shrivers
shriving15268453shriving
shrove125412223shrove_
strive95020963strive_
strived114713663strived
striver104315203striver
strives104119373strives
tardive1136893tardive_
taximen1644923taximen
terreen7257573terreen
thein85919023thei__n
theine94814923theine_
theines104013233theines
then78429693th___en
therian10311293theri_an
thicken16317873thicken
thief114516293th_i_ef
thieve1235963th_ieve
thieved1434973thieved
thieves1346903thieves
thin76732383th_i__n
thine85026853th_ine_
thirled11328093thirled
thirteen1143303thirteen
thorite10313443thorite_
thorites11312393thorites
thrawed1435583thrawed
thrawn12769423thr_awn
threaten1146303threaten
three87526913thr__ee
threep115910113thr_eep
threes97117323thr_ees
threw1117315713thr__ew
thrift12412043thri_ft
thrifts1335523thrifts
thrifty1634193thrifty
thrill94910593thri_ll
thrilled1235493thrilled
thriller1165553thriller
thrills10398783thrills
thrip103012183thri__p
thrips11299013thri_ps
throe89321423thr_oe_
throes97518673thr_oes
throne98517603throne_
throned115412173throned
thrones105715843thrones
thrower1386993thrower
thrown1214911443thr_own
thurifer1443273thurifer
tirrivee1143613tirrivee
tories65435883tori_es
torten65314353tor_ten
trave85223033t_rave_
travel94112983t_ravel
traves94222743t_raves
treen55622753t_r_een
trevet94818913t_revet
tribe74420263t_ribe_
tribes85119023t_ribes
trice75127493t_rice_
triced95518673t_riced
tricep103911073t_ricep
trices84826333t_rices
trident8314193t_rident
tried65026913t_ri_ed
triene64316383t_ri_ene
triens65417543t_ri_ens
trier54328533t_ri_er
tries55742813t_ri_es
trigon74513103t_rigon
trijet133916553t_rijet
trike95320163t_rike_
trikes105419493t_rikes
trimer85717153t_rimer
trine54734603t_rine_
trined74920713t_rined
trines64132563t_rines
tripe75425383t_ripe_
tripes85324873t_ripes
trite54730033t_rite_
triter65120593t_riter
triton63914893t_riton
triune64210183t_riune
trivets103911583t_rivets
trivia938503t_rivia
trove85221923t_rove_
trover95014663t_rover
troves94719113t_roves
tureen63312723tur_een
turfmen1244163turfmen
turion6313163turi_on
turves94212693tur_ves
unrisen7229283unrisen
unroven10238143unroven
uprisen9227353uprisen
upriver12196933upriver
whiten124111923wh_iten

Search took 9 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.1531167915.0
2DLD Change Limit1340271837.89316980.5
3Display Results1831830.0632904.8
 (SQL Overall)1786911838.10922036.1
 
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.