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

63 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
tritomas104803(None) 
tritoma948051tritoma_
teratomas1146372teratomas
trisomes1039832trisomes
tritones83413442tritones
tritons73814882trito_ns
aromas81018613ar__omas
britskas14132713britskas
britzkas23132053britzkas
citolas939363_citolas
epitomes1257713epitomes
gliomas1035333gli_omas
keratomas1544463keratomas
lipomas1156443_lipomas
primas104418103pri__mas
prosomas1249723prosomas
riojas1335813_ri_ojas
scotomas1256263scotomas
stomas84816323__stomas
teratoma1047143teratoma_
titman82711003t_it_man
trachomas16126413trachomas
traitors8310793traito_rs
traumas938593tr_aumas
triatomic1344293triatomic
trichomes16107553trichomes
tricorns1036683tricorns
tricots9311563trico_ts
trifocal1345033trifocal
trifocals1444043trifocals
trigonal946243trigonal
trigons84312093trigo_ns
trigos74214173trigo__s
trigrams11116353trigrams
trilobal1044373trilobal
trims75021473tri__m_s
trinodal945443trinodal
trinomial1156233trinomial
trinomials1254313trinomials
triodes84012503tri_odes
triols66117803tri_o_ls
trios55528093tri_o__s
trioses75015653tri_oses
tripodal1145143tripodal
tripods10359053tripo_ds
tripolis1038713tripolis
tripos84014923tripo__s
triposes1039973triposes
triptycas1642633triptycas
triremes1035523triremes
trisemes1036643trisemes
trismus935563tri_smus
trisome9310223trisom_e
trisomic1245943trisomic
trisomics1343853trisomics
trisomies1147163trisomies
trisomy1235943trisom_y
tristezas1842743tristezas
tritiums1056393tritiums
triton63914893trito__n
tritone73613883trito_ne
tromps104911703tr__omps
tronas63816903tr__onas

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.423422437.4
2DLD Change Limit146162637.17020385.2
3Display Results63630.0163937.5
 (SQL Overall)178691637.60923484.2
 
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.