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

61 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
triploid114736(None) 
triploids1245891triploids
triploidy1543681triploidy
arilloid946622arilloid
diploid11310292_diploid
trichoid1457812trichoid
tripled104113832tripl_ed
tripod9399852trip_o_d
tripoli937132tripoli_
tripolis1038712tripolis
cricoid1239253cri_coid
crinoid1039943cri_noid
diploic1247763_diploic
diploids1247843_diploids
diploidy1544733_diploidy
ericoid1049893eri_coid
euploid1038963_euploid
haploid1339833_haploid
lipoid9411043_lip_oid
prismoid1344983prismoid
ripcord1264463_ripcord
shipload1464343shipload
sialoid8310963_sialoid
strophoid1567203strophoid
tabloid1048263t_abloid
tetraploid1354213tetraploid
thalloid1246283thalloid
tiptoed1036143t_iptoed
trainload1043213trainload
trapezoid2153313trapezoid
trendoid1045453trendoid
trepid9310083trep__id
triacid1038593tri_acid
triclad1037443tricl_ad
trifid1039063tri__fid
trifled113711963trifl_ed
trifold1136243tri_fold
trilled84116313tri_lled
trillion847973trillion
trilobed1144203tri_lobed
trilogy1136013tri_logy
trioxid1546613tri_oxid
triplane1039113triplane
triple84215923tripl__e
triples94616873tripl_es
triplet94319213tripl_et
triplets103510263triplets
triplex16447803tripl_ex
tripling112712553tripling
triplite1039103triplite
triploidies1452603triploidies
triply114211023tripl__y
tripodic1345333tripodic
tripods10359053trip_ods
tripody13395983trip_ody
tripos84014923trip_o_s
tripped123911693trip_ped
trochoid1468443trochoid
typhoid1648133t_yphoid
varioloid1344063varioloid
xiphoid2045923_xiphoid

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 Filter1786911461620.423422437.4
2DLD Change Limit146162617.34319904.9
3Display Results61610.0163812.5
 (SQL Overall)178691617.78222962.1
 
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.