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

127 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
triazin163820(None) 
thiazin1945481thiazin
triazine1738501triazine
triazins1738351triazins
diazin1639162_diazin
thiamin1236932thiamin
thiazine2045252thiazine
thiazins2045312thiazins
train56529112tr_a_in
triacid1038592triacid
triadic1037832triadic
triaging102610542triaging
triazines1847542triazines
atrazine1748403atr_azine
brain76229383br_a_in
brazen174812453br_azen
brazil1779623br_azil
brazing193715113br_azing
crazing193914583cr_azing
creatin93618133creatin
diamin9312523_diamin
diazine1738933_diazine
diazins1739183_diazins
drain65222893dr_a_in
frazil1847223fr_azil
frizing203310873fri_zing
frizzing2064803frizzing
gliadin935593gliadin
gradin83517483gr_adin
grain65126253gr_a_in
gratin74520583gr_atin
grazing183514553gr_azing
griffin1434513griffin
griskin1236013griskin
niacin8310223_niacin
ordain7810403orda_in
origin7311033ori_gin
priapi1037923priapi_
priapic1346023priapic
prizing193514683pri_zing
rain46251733_r_a_in
raisin62716923_raisin
ravin85624653_r_avin
rawin85521473_r_awin
razing164524543_r_azing
reagin74915533_reagin
ricin74620213_ri_cin
seizin153610853sei_zin
strain64919573str_a_in
striating10914193striating
striation9313483striation
tailfin1035693tailfin
tain45548073t__a_in
takin94921303t__akin
tamarin9311913tamarin
terrain7410853terra_in
terrapin1046203terrapin
thiamine1346773thiamine
thiamins1346633thiamins
thiazide2143033thiazide
thiazines2144643thiazines
thiazol1942623thiazol
thionin1048673thionin
tiepin839343t_iepin
tiffin12327933t_iffin
topazine1944983topazine
tracing103720153tr_acing
trading93517973tr_ading
tragi64717173tr_agi_
tragic93811543tr_agic
traik95418203tr_a_ik
traiking132511973traiking
trail55126773tr_a_il
trailing92916093trailing
training93015863training
trains64725343tr_a_ins
trait56940843tr_a_it
trapan82412973tr_apan
treading103515333treading
treason748763treason
treating92519613treating
triable92515393triable
triac74116373tria__c
triacids1146723triacids
triacs83913223tria_cs
triad65217723tria__d
triadics1146133triadics
triadism1147553triadism
triads74513533tria_ds
triage72812893tria_ge
triaged92810443triaged
triages82613793triages
trial54926353tria__l
trials64319883tria_ls
triassic1044633triassic
triaxial1545663triaxial
triazole1744153triazole
tribadic1344103tribadic
tribasic1244793tribasic
trichina1348093trichina
tricing103417353tri_cing
trickie132611033trickie
tricking152714513tricking
tricorn937963tricorn
trifid1039063tri_fid
trifling122411503trifling
trigging11299583trigging
trigon74513103tri_gon
trilling92815963trilling
trillion847973trillion
trimaran1045643trimaran
trimming13318653trimming
trining82919213tri_ning
trioxid1546613trioxid
tripling112712553tripling
tripping133210923tripping
triptan947543triptan
trismic1137483trismic
trithing122811773trithing
triton63914893tri_ton
trivia938503tri_via
troaking133310973troaking
tropin83316753tr_opin
trypsin1245113trypsin
twain86313623t_wa_in
tzitzis1542423tzitzis
tzitzit1542703tzitzit

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271277.42318055.6
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.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.