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
triform123786(None) 
aciform1446022aciform
aeriform1346102aeriform
aliform1247042aliform
arciform1544802arciform
auriform1345192auriform
biform1368132_biform
deiform1336702deiform
gruiform14103382gruiform
lyriform1643552lyriform
oviform1544822oviform
piriform1555762piriform
preform1439622preform
pyriform1844412pyriform
reform11312722_reform
tricorn937962tricorn
trifold1136242trifold
triforia1145652triforia
triforium1444332triforium
triformed1543732triformed
tubiform1543742tubiform
uniform1247062uniform
ursiform1343762ursiform
variform1645012variform
vitriform1743332vitriform
ausform1245243ausform
bursiform1642453bursiform
cirriform1643523cirriform
coliform1545573coliform
conform14310463conform
cordiform1743973cordiform
cruciform1843173cruciform
cubiform1744023cubiform
cuniform1555033cuniform
deform1259633_deform
ensiform1344363ensiform
filiform1644783filiform
form95836873___form
freeform1644713freeform
fusiform1643993fusiform
gasiform1444313gasiform
inform11310153_inform
isoform1244963isoform
janiform2044733janiform
libriform1642843libriform
misform1437513misform
napiform1543773napiform
omniform1544013omniform
paraform1546943paraform
pediform1645193pediform
perform1439293perform
piciform1765003piciform
piliform1555483piliform
pisiform1564973pisiform
preforms1537413preforms
preinform1644763preinform
prior74316173pri_or_
priors83914483pri_ors
priory114110263pri_ory
proforma1545433proforma
ramiform1544713ramiform
reforms1239823_reforms
reinform1346203reinform
reniform1346243reniform
retiform1345873retiform
rifer84721983_rifer_
rigor62714053_rigor_
rigors72813713_rigors
rotiform1344673rotiform
setiform1345013setiform
slipform1543583slipform
stipiform1642363stipiform
stratiform1552473stratiform
stridor8467393stridor_
stridors9367323stridors
styliform1742513styliform
tailor63412503tailor_
tailors73212393tailors
telford1145163telford
terraform1443603terraform
traitor7310123traitor_
traitors8310793traitors
transform1446203transform
trefoil1066063trefoil
tremor84210403tremor_
tremors93711233tremors
tricorne1045963tricorne
tricorns1036683tricorns
tricot8317753trico_t
tricots9311563tricots
triduum1043413triduum
trier54328533tri_er_
triers64321523tri_ers
trifid1039063trif_id
trifle94012883trif_le
trifled113711963trifled
trifler103912153trifler
triflers113110223triflers
trifles103814833trifles
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
unciform1544663unciform
uniforms1355043uniforms
vasiform1644243vasiform
vermiform1953323vermiform

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.50017870.3
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.