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

137 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
triform123785(None) 
aciform1446012aciform
aeriform1346092aeriform
aliform1247032aliform
arciform1544792arciform
auriform1345182auriform
biform1368122_biform
deiform1336692deiform
gruiform14103372gruiform
lyriform1643542lyriform
oviform1544812oviform
piriform1555752piriform
preform1439612preform
pyriform1844402pyriform
reform11312712_reform
tricorn937962tricorn
trifold1136242trifold
triforia1145642triforia
triforium1444332triforium
triformed1543732triformed
tubiform1543732tubiform
uniform1247052uniform
ursiform1343752ursiform
variform1645002variform
vitriform1743322vitriform
ausform1245233ausform
bursiform1642443bursiform
cirriform1643513cirriform
coliform1545563coliform
conform14310463conform
cordiform1743963cordiform
cruciform1843163cruciform
cubiform1744013cubiform
cuniform1555023cuniform
deform1259623_deform
ensiform1344353ensiform
filiform1644773filiform
form95836873___form
freeform1644703freeform
fusiform1643983fusiform
gasiform1444303gasiform
inform11310153_inform
isoform1244963isoform
janiform2044723janiform
libriform1642833libriform
misform1437513misform
napiform1543763napiform
omniform1544003omniform
paraform1546933paraform
pediform1645183pediform
perform1439283perform
piciform1764993piciform
piliform1555473piliform
pisiform1564963pisiform
preforms1537403preforms
preinform1644753preinform
prior74316173pri_or_
priors83914483pri_ors
priory114110263pri_ory
proforma1545433proforma
ramiform1544703ramiform
reforms1239823_reforms
reinform1346193reinform
reniform1346233reniform
retiform1345863retiform
rifer84721983_rifer_
rigor62714053_rigor_
rigors72813713_rigors
rotiform1344663rotiform
setiform1345003setiform
slipform1543573slipform
stipiform1642353stipiform
stratiform1552463stratiform
stridor8467393stridor_
stridors9367323stridors
styliform1742503styliform
tailor63412503tailor_
tailors73212393tailors
telford1145153telford
terraform1443593terraform
traitor7310123traitor_
traitors8310793traitors
transform1446193transform
trefoil1066063trefoil
tremor84210403tremor_
tremors93711233tremors
tricorne1045963tricorne
tricorns1036683tricorns
tricot8317753trico_t
tricots9311563tricots
triduum1043413triduum
trier54328533tri_er_
triers64321523tri_ers
trifid1039063trif_id
trifle94012883trif_le
trifled113711963trifled
trifler103912153trifler
triflers113110213triflers
trifles103814823trifles
trifocal1345033trifocal
trifolium1443243trifolium
trigo65716053trigo__
trigon74513103trigo_n
trigons84312093trigons
trigos74214173trigo_s
trigram1077763trigram
trilogy1136013trilogy
trim65329523tri___m
trimer85717153trimer_
trimers94615143trimers
trimorph1543623trimorph
trinary1039173trinary
trio45233343tri_o__
triode75311893tri_ode
triol55521363tri_o_l
triols66117803tri_ols
trios55528093tri_o_s
triose64715383tri_ose
tripart9311433tripart
tripod9399853tripo_d
tripods10359053tripods
tripody13395983tripody
tripoli937133tripoli
tripos84014923tripo_s
trisome9310223trisome
trisomy1235943trisomy
triter65120593triter_
tritium969013tritium
tritoma948053tritoma
triton63914893trito_n
tritone73613883tritone
tritons73814883tritons
trivium1256143trivium
unciform1544653unciform
uniforms1355043uniforms
vasiform1644233vasiform
vermiform1953313vermiform

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.406440125.6
2DLD Change Limit1340271377.45317983.0
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.92222556.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.