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

69 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
triumph145334(None) 
triumphs1542511triumphs
triumphal1652212triumphal
triumphed1741942triumphed
trump95615122tr_ump_
trumps104611882tr_umps
atrium8411823atrium__
atriums939043atrium_s
bumph144911983__bumph
crimp115615803cri_mp_
crimps124613453cri_mps
crimpy15489393cri_mpy
crump115616423cr_ump_
crumps124514343cr_umps
frump126912563fr_ump_
frumps13479783fr_umps
frumpy16466883fr_umpy
galumph15102663galumph
grump105115313gr_ump_
grumphy18443623gr_umphy
grumps114510573gr_umps
grumpy14498153gr_umpy
harrumph1841603harrumph
harumph1742933harumph
humph155712213__humph
primp115615923pri_mp_
primps124711823pri_mps
rump86729083_r_ump_
rumps95922293_r_umps
thump126211573t_hump_
thumps13449353t_humps
tramp96319773tr_amp_
tramps105114453tr_amps
trampy13499253tr_ampy
trauma838803traum_a
traumas938593traumas
tricep103911073tricep_
triceps11267343triceps
triglyph1741673triglyph
trigraph1445703trigraph
trilith10310513trilith
trim65329513tri_m__
trimer85717153tri_mer
trimly114410893tri_mly
trimmed12348933trimmed
trimmer113610833trimmer
trimorph1543623trimorph
trims75021473tri_m_s
trip66830393tri__p_
tripe75425383tri__pe
trippy13457803tri_ppy
trips74923363tri__ps
trismic1137483trismic
trismus935563trismus
triumphant1752173triumphant
triumphing1842243triumphing
triumvir1341573triumvir
triune64210183triu_ne
triunes74311383triunes
tromp95815803tr_omp_
trompe105611263tr_ompe
tromps104911703tr_omps
trough108512023trou_gh
troupe84812433trou_pe
trumped12439713tr_umped
trumpet113810723tr_umpet
truth85214153tr_u_th
tump85927033t__ump_
tumps95420793t__umps

Search took 10 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.1561145455.1
2DLD Change Limit134027699.06314788.4
3Display Results69690.0461500.0
 (SQL Overall)178691699.26519286.7
 
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.