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 “tenorist” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
tenorist841302(None) 
tenorists948191tenorists
centrist10314862centrist
tenebrist1145642tenebrist
tennist72813112ten_nist
tenorite8311992tenorite
tenors63217752tenor_s_
terrorist988552terrorist
theorist1149552theorist
amorist9317643_amorist
aorist64827873__aorist
aphorist13412503aphorist
arborist10411613arborist
canoeist10310693canoeist
canonist10513533canonist
centrism1249643centrism
centrists11410233centrists
colorist102818993colorist
deforest1238793deforest
demonist11413463demonist
demotist11311843demotist
dentist8316743den_tist
denturist1048463denturist
egoist7612283_ego_ist
egotist8411273_egotist
encrust947873_encrust
enlist6417043_en_list
enokis103010273_enokis_
enosis63816423_enosis_
entrust7410883_entrust
entwist1048803_entwist
exorcist1746873_exorcist
florist10314243_florist
genoise839423geno_ise
gnomist1049133_gnomist
hedonist1249553hedonist
humorist1348783humorist
kenosis11369003kenosis_
meliorist1148463meliorist
melodist1149743melodist
memoirist1345983memoirist
memorise121411433memorise
metrist9317063me_trist
monodist11310923monodist
motorist10314413motorist
nepotist1059233nepotist
noris54928273__noris_
recordist1246923recordist
reforest1139963reforest
reformist1445913reformist
rigorist949123rigorist
scenarist1147823scenarist
senoras72714953senoras_
senores73218113senores_
senorita848283senorita
senors63620783senor_s_
stenosis847993stenosis_
tanist6324593tan__ist
tantrism1048373tantrism
teariest82417263te_ariest
temporise1347403temporise
tenderest1047903tenderest
tendril836783tendri_l
tendrils946443tendrils
tenebrism1343293tenebrism
tenebrists1243593tenebrists
tennis64015303ten_nis_
tennists8297793ten_nists
tenoning938893tenoning
tenons62916603teno_ns_
tenor53620253tenor___
tenorites9311083tenorites
tenours72610053tenours_
tensest72713313ten_sest
tensorial9116783tensorial
tensors72712373tensor_s_
tentiest82115613tentiest
tentoria8119263tentori_a
tentorial9119593tentorial
tentorium1146803tentorium
tenuis64213083ten_uis_
tenures7412013tenures_
tenurial847703tenurial
tenuring938863tenuring
territ63421373te_rri_t
territs72714493te_rrits
terrorise997153terrorise
terrorism1186433terrorism
terrorists1085603terrorists
tetris62816293te_tris_
theorise1137873theorise
theorists1246593theorists
threnodist1453203threnodist
tourist7313203t_ourist
tsarist7712253t_sarist
tsooris734693tsooris_
tsoris63411193t_soris_
tzarist1659103t_zarist
verist93823893ve__rist
xenocryst2152023xenocryst

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621006.92321112.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.10925135.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.