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

133 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
trivial103871(None) 
trivia938501trivia_
rival85216502_riv_al
tibial849842t_ibial
travail1036552travail
trial54926352tr__ial
triaxial1545662triaxial
tribal8611132tri_bal
trinal6516962tri_nal
trivially1545142trivially
trivium1256142trivium
altricial1146213altricial
arrival1037563arriv_al
arval86017013ar_v_al
atrial65418943atr__ial
bridal9511453bri_dal
civil103411933_civi_l
clivia1177233clivia_
clivias1266693clivias
cranial92114683cranial
criminal1248303criminal
crissal937413crissal
critical12310263critical
crucial1157893crucial
drivel105110383driv_el
driving123910713driving
eluvial1045853eluvial
ervil8310303er_vi_l
exuvial1744253exuvial
filial93013253_filial
finial92814183_finial
fluvial1345363fluvial
frivol1235113friv_ol
gavial10310083_gavial
gremial1039153gremial
ilial55317843__ilial
initial7311883initial
jovial1636543_jovial
lixivial1842943lixivial
nival84915773_niv_al
nontrivial1354873nontrivial
ogival1035873ogiv_al
original956793original
outrival1145323outriv_al
peridial11411923peridial
pluvial1245433pluvial
predial103815413predial
prevail1238243prevail
primal104014623pri_mal
privier122910453privier
privies122414263privies
privily15207623privily
privity15268313privity
proviral1346493proviral
racial83419243_racial
radial74020393_radial
redial74923113_redial
retial64724993_retial
reveal94115053_reveal
revisal1038263_revisal
revival1337033_revival
rial45938093_r__ial
rictal83113183_rictal
ritual6310623_ritual
rivals94213183_riv_als
riving104521423_riving
riyal84413433_ri_yal
stibial946583stibial
strigil837263strigi_l
striving122611393striving
telial65815363t_elial
tertial7313863tertial
thriving15246353thriving
tibia7312403t_ibia_
tibiae838483t_ibiae
tibias839953t_ibias
tical76021493t_i_cal
tidal64516443t_i_dal
timbal102510753t_imbal
tincal83913363t_incal
tineal66216163t_ineal
titian62512663t_itian
tragical1148213tragical
trail55126773tr_ai_l
travails1146083travails
travel94112983trav_el
trenail7410813trenail
triac74116373tr__iac
triad65217723tr__iad
trials64319883tr__ials
tribals9610753tri_bals
tribunal10104673tribunal
trichinal1445663trichinal
tricing103417353tricing
triclad1037443triclad
triennial945063triennial
trifacial1444693trifacial
trifid1039063trifi_d
trifocal1345033trifocal
trigonal946243trigonal
trigram1077763trigram
trilith10310513trilith
trill55122933tr__ill
trilobal1044373trilobal
trining82919213trining
trinity10310843trinity
trinodal945443trinodal
trinomial1156233trinomial
triol55521363tr__iol
tripedal1144673tripedal
tripodal1145143tripodal
triptan947543triptan
trishaw1344753trishaw
triticale1147513triticale
tritium969013tritium
trivalve1443943triv_alve
trivet93721883triv_et
trivets103911583trivets
trivialise1365163trivialise
trivialist1366073trivialist
triviality1644443triviality
trivialize2285633trivialize
trochal1288243trochal
troopial1045483troopial
tropical1248733tropical
troupial1044183troupial
trysail1044543trysail
twibil1133563twibi_l
twibill1242743twibill
uredial82910483uredial
urial54823023ur__ial
urinal6614123uri_nal
vial76731093___vial

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.420425454.8
2DLD Change Limit1340271336.67320085.0
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.13925030.3
 
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.