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 “triacids” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
triacids114671(None) 
triacid1038581triacid_
diacids1137852_diacids
triacs83913222triac__s
triadics1146122triadics
triads74513522tria__ds
triazins1738342triazins
trioxids1644442trioxids
acids87121003___acids
antacids1148323antacids
aramids102810503ar_amids
braids95015683br_a_ids
briards10398553bria_rds
cricoids1347183cricoids
crinoids1147353crinoids
diacid10310633_diacid_
friaries11310083friaries
monacids13137503monacids
niacins938543_niacins
nonacids11148253nonacids
oribatids1242843oribatids
oxyacids2162103oxyacids
peracids13310073peracids
piracies12312643piracies
primacies1548453primacies
privacies1646803privacies
raids65827513_r_a_ids
ranids75118703_r_anids
rapids94913893_r_apids
ricins83618703_ri_cins
sialids839723_sialids
tabanids1144963tabanids
teiids736693tei__ids
tetracids1245903tetracids
thiamins1346603thiamins
thiazide2143023thiazide
thiazides2242773thiazides
thiazins2045303thiazins
tineids8337873t_ineids
traced94821583tr_aced_
tracers94917833tr_acers
traces85329933tr_ac_es
tracheids1545053tr_acheids
tracing103720153tr_acing
tracings112910403tr_acings
tracks124818843tr_ac_ks
tracts85019073tr_ac_ts
tragics10338083tr_agics
traiks104013713tr_a_iks
trails64622513tr_a_ils
trains64725343tr_a_ins
traits65121983tr_a_its
treacles1039703treacles
treads74817913trea__ds
treaties8316983treaties
triac74116373triac___
triad65217723tria__d_
triadic1037823triadi_c
triadism1147553triadism
triadisms1246443triadisms
triaged92810443triaged_
triages82613793tria_ges
triaging102610543triaging
trials64319883tria__ls
triarchies1544553triarchies
triaxial1545663triaxial
triazin1638193triazi_n
triazine1738503triazine
triazines1847543triazines
triced95518673tri_ced_
triceps11267343tri_ceps
trices84826333tri_c_es
tricing103417353tri_cing
tricks125319013tri_c_ks
triclads1146223triclads
tricots9311563tri_cots
trifacial1444693trifacial
trifacials1553013trifacials
trifid1039063tri_fid_
trilbies1037693trilbies
trioxid1546613trioxid_
trioxide1644793trioxide
trioxides1744473trioxides
tripacks1664893tripac_ks
triploids1245883triploids
tripods10359053tri_pods
truancies1146873truancies
uracils939373ur_acils

Search took 10 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.1561145455.1
2DLD Change Limit146162889.37615589.0
3Display Results88880.0302933.3
 (SQL Overall)178691889.56218687.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.