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

132 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
triazins173835(None) 
thiazins2045311thiazins
triazin1638201triazin_
triazine1738501triazine
triazines1847541triazines
diazins1739182_diazins
thiamins1346632thiamins
thiazin1945482thiazin_
thiazine2045252thiazine
thiazines2144642thiazines
trains64725342tr_a_ins
triacids1146722triacids
triadics1146132triadics
triaging102610542triaging
atrazine1748403atr_azine
atrazines1846683atr_azines
brains85125473br_a_ins
brazens18418713br_azens
brazils1867753br_azils
brazing193715113br_azing
crazies183413853cr_azies
crazing193914583cr_azing
creatins103617513creatins
diamins10312213_diamins
diazin1639163_diazin_
diazine1738933_diazine
diazines1838713_diazines
drains73719403dr_a_ins
frazils1956123fr_azils
friaries11310083friaries
frizing203310873fri_zing
frizzies19315933frizzies
frizzing2064803frizzing
gliadins1035193gliadins
gradins93416233gr_adins
grains74223093gr_a_ins
gratins84119183gr_atins
grazing183514553gr_azing
grazings19337263gr_azings
griffins1544783griffins
griskins1335953griskins
niacins938543_niacins
ordains879653orda_ins
origins8310463ori_gins
prizing193514683pri_zing
rains55140233_r_a_ins
raisins72715343_raisins
ravins94622563_r_avins
rawins95617623_r_awins
razing164524543_r_azing
reagins84215643_reagins
ricins83618703_ri_cins
seizins164010133sei_zins
strains74218153str_a_ins
striating10914193striating
striations10312793striations
tailfins1135443tailfins
tains54936323t__a_ins
takins105117403t__akins
tamarins10310843tamarins
terrains8410323terra_ins
terrapins1146183terrapins
thiamin1236933thiamin_
thiamine1346773thiamine
thiamines1446383thiamines
thiazide2143033thiazide
thiazides2242783thiazides
thiazols2042473thiazols
thionins1177923thionins
tiepins939463t_iepins
tiffins13327983t_iffins
tizzies15287893t_izzies
topazine1944983topazine
tracing103720153tr_acing
tracings112910413tr_acings
trading93517973tr_ading
tragics10338083tr_agics
traiking132511973traiking
traiks104013713tr_a_iks
trailing92916093trailing
trails64622513tr_a_ils
train56529113tr_a_in_
training93015863training
trainings10246723trainings
traits65121983tr_a_its
trans54933043tr_a__ns
trapans92812463tr_apans
treading103515333treading
treasons848683treasons
treaties8316983treaties
treating92519613treating
triacid1038593triaci_d
triacs83913223tria__cs
triadic1037833triadi_c
triadism1147553triadism
triadisms1246453triadisms
triads74513533tria__ds
triages82613793tria_ges
trials64319883tria__ls
triaxial1545663triaxial
triazole1744153triazole
triazoles1844393triazoles
trichina1348093trichina
trichinas1446043trichinas
tricing103417353tri_cing
tricking152714513tricking
tricorns1036683tricorns
triens65417543tri__ens
trifling122411503trifling
triflings13235973triflings
trigging11299583trigging
trigons84312093tri_gons
trilbies1037693trilbies
trilling92815963trilling
trillions947183trillions
trimarans1144693trimarans
trimming13318653trimming
trimmings14254453trimmings
trining82919213tri_ning
trioxids1644443trioxids
tripling112712553tripling
tripping133210923tripping
trippings14225723trippings
triptans1047363triptans
trithing122811773trithing
trithings13246603trithings
tritons73814883tri_tons
troaking133310973troaking
tropins93116313tr_opins
trypsins1344903trypsins
twains95811183t_wa_ins
tzitzis1542423tzitzi_s

Search took 7 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.403443402.0
2DLD Change Limit1461621326.45622639.7
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.90525878.5
 
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.