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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
transiences1312827(None) 
transience12128431transience_
transiencies1456001transiencies
transgenes1148402transgen_es
transiency15135422transienc_y
transients1078902transien_ts
transpierces1654682transpierces
intransigences17122683intransigences
tangences1246443t_an_gences
transcended1554503transcended
transcends1345473transcen_ds
transduces1345603trans_duces
transects1157823trans_e_cts
transfects1545723transfe_cts
transferees1456073transferees
transferences1853683transferences
transgender1354193transgender
transgene1047953transgen_e_
transient9713213transien__t
transiently1455773transiently
translucences1793573translucences
transparences17103753transparences
transpierce1554853transpierce_
transpierced1753513transpierced
transverses1445903transverses
absences1247674__abs_ences
ambiences1545254__ambiences
audiences1246004__audiences
brassieres12274384brassie_res
consciences1447024_consciences
evanescences1953234evanescences
faiences1337044_fa__iences
grandnieces1552024grandnie_ces
intransigeances18131764intransigeances
intransigence16112874intransigence_
leniences1148144_len_iences
nascences1346234_na_scences
nonsciences1556094_nonsciences
patiences1367434_pa_tiences
presciences17127274presciences
presences132113794pr_es_ences
pruriences1444704pr_uriences
radiances1247694_ra_diances
renascences1554864_renascences
renitences1248444_renitences
residences1368234_r_esidences
saliences11108064_sa_liences
sapiences13116424_sa_piences
sentiences1247604_sentiences
tangence1146704t_an_gence_
tangencies1345754t_an_gencies
tansies74521244t_ansi___es
tarriances1244214t_arriances
tendences1248084t_en_dences
tenpences1346544t_en_pences
tragediennes146974tragediennes
trainees82712064tra__i_nees
tramlines1139844tramli_n_es
trances93919644tra____nces
trannies8415014tran___nies
transacts1157364trans__acts
transaxles1745064trans_axles
transceiver1664224transceiver
transceivers1753064transceivers
transcend1246444transcen__d
transcendences1962214transcendences
transcendent1563714transcendent
transcribes1556174transcribes
transduce1245214trans_duce_
transduced1444234trans_duced
transducer1354454trans_ducer
transducers1453584trans_ducers
transect10410054trans_e_c_t
transected1347314trans_ected
transepts1146384trans_e_pts
transfect1446734transfe_c_t
transfected1745354transfected
transferals1455214transferals
transferase1455454transferase
transferases1555084transferases
transferee1347254transfe_ree
transference1754314transference_
transferors1484494transferors
transferred1554604transferred
transferrer1454694transferrer
transferrers15133664transferrers
transfers1238054transfe__rs
transfigures1653254transfigures
transfixes2046474trans_fixes
transfuses1346744trans_fuses
transgenic1355774transgen_ic
transgresses1354154transgresses
transhumances2072284transhumances
transistors1155744transistors
transited10410604transi__ted
transitions1148924transitions
transitive1348494transitive_
transits8313504transi___ts
translates10411704trans_lates
translucence16113964translucence_
translucencies1862224translucencies
transmittances18182754transmittances
transmutes1247304trans_mutes
transparence1694104transparence_
transparencies1892724transparencies
transpires1249314trans_pires
transponder1454374transponder
transponders1563354transponders
transposes1247444trans_poses
transshapes1674314transshapes
transudates1246374transudates
transudes1047594trans__udes
transvalues1454074transvalues
transverse1345904transverse_
traplines11310374trapli_n_es
trienes74118414tr___ien_es
trientes82812124tr___ientes
truculences1582624truculences
tumescences1754154tumescences
turgescences1752844turgescences

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191208.71617074.2
3Display Results1201200.0631904.8
 (SQL Overall)1786911209.20219418.7
 
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.