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

105 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
trinities931334(None) 
triunities1046101triunities
aminities11312912aminities
aridities10911632aridities
crinites10612762crinit_es
privities14312042privities
abilities11714143abilities
acidities12810183acidities
acridities1348293acridities
affinities1645713affinities
agilities10810973agilities
amenities11310433amenities
anilities9516003anilities
arenites8917103arenit_es
atrocities1248593atrocities
avidities13107613avidities
bovinities1546013bovinities
brevities1446423brevities
brinies93317913brin__ies
caninities12410493caninities
canities101519263_canities
crinite9513633crinit_e_
crudities1247743crudities
dainties9312403dain_ties
dignities1149593dignities
dimities11314003_dimities
divinities1447733divinities
equinities1947373equinities
eternities1048063eternities
felinities1349433felinities
feminities1549673feminities
finites10315923_finit_es
fixities1838213_fixities
granites92116363granit_es
gravities1338303gravities
inanities9312443inanities
infinities1369443infinities
kainites1238793kainit_es
latinities10410163latinities
lenities8315943_lenities
minifies13312903_minifies
moronities1249063moronities
nineties8312913_nineties
oralities91214123oralities
ornithes1136423or_nithes
pinites9319533_pinit_es
primitives1745623primitives
priorities1249153priorities
probities13312653probities
putridities1444913putridities
rarities8316333_rarities
rhinitides1443663rhinitides
rhinitis1145263rhiniti_s
righties12711573_righties
salinities10410953salinities
sanities81219773_sanities
serenities10411063serenities
sterilities11129013sterilities
tensities9311333tensities
tenuities949763tenuities
tepidities1347713tepidities
thirties1139723thi_rties
timidities1346553timidities
titties73617363t_i_tties
tonicities12410363tonicities
torosities1048263torosities
torpidities1444803torpidities
torridities1244493torridities
toxicities1947283toxicities
trannies8415013tran_nies
treaties8316983tr_eaties
trendies9312213tren_dies
tributes1047233tribut_es
trichites1448883trichit_es
tricotines1247453tricotines
trientes82812123trient_es
trilbies1037693tri_lbies
triliths1145953trilit_hs
trilogies1048173trilogies
trindles93211683trin_dles
trines64132563trin___es
trinity10310843trinit__y
trinketries15354313trinketries
triplites1148283triplit_es
tripodies1246573tripodies
trisomies1147163trisomies
troilites948433troilit_es
trusties82712853tr_usties
tumidities1345893tumidities
turbidities14174553turbidities
turgidities13174263turgidities
twenties1137503twen_ties
twinkies1535983twin_kies
unities72520153__unities
uranites82514643uranit_es
urbanities1245333urbanities
urinaries949203urinaries
urinates8314133urinat_es
utilities9610803utilities
vanities111414493_vanities
vicinities1547463vicinities
vinifies1439873_vinifies
virginities1544023virginities
viridities14106903viridities
virilities1379123virilities

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411057.15620771.5
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.62523434.9
 
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.