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

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

78 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
translucences179357(None) 
translucence16113961translucence_
translucencies1862221translucencies
translucency19132792translucenc_y
transferences1853683transferences
transhumances2072283transhumances
transiences13128273trans__iences
translucent1355433translucen__t
translucently1882303translucently
transparences17103753transparences
transcended1554504trans__cended
transcendences1962214transcendences
transcends1345474trans__cen_ds
transducers1453584transduce__rs
transduces1345604transdu___ces
transference1754314transference_
transgenes1148404trans__gen_es
transhumance1972544transhumance_
transience12128434trans__ience_
transiencies1456004trans__iencies
translocates1455394transloc_ates
transparence1694104transparence_
transparencies1892724transparencies
transpierces1654684trans_pierces
affluences18103355__afflu_ences
candescences1654495_candescences
confluences1855095_conflu_ences
evanescences1953235evan_escences
frankincenses225945frankincenses
fraudulences1861585fra_udulences
influences1545655__influ_ences
intransigences17122685intrans_igences
lucences12137315_____lucences
nascences1346235_na_s__cences
radiolucencies1971465_radiolucencies
refluences1545515_r_eflu_ences
renascences1554865_ren_ascences
tangences1246445t_an___gences
transceiver1664225trans__ceiver
transceivers1753065trans__ceivers
transcend1246445trans__cen__d
transcendence1862555transcendence_
transcendencies2071585transcendencies
transcendent1563715trans__cendent
transcribes1556175trans__cribes
transduce1245215transdu___ce_
transduced1444235transdu___ced
transducer1354455transdu___cer
transducing1554355transducin__g
transductants1672545transductants
transductions1664295transductions
transects1157825trans___e_cts
transfects1545725trans__fe_cts
transferees1456075trans__ferees
transfuses1346745transfu___ses
transgender1354195trans__gender
transgene1047955trans__gen_e_
transgresses1354155trans_gresses
transhumants1762895transhuman_ts
transiency15135425trans__ienc_y
transients1078905trans__ien_ts
translates10411705transl___ates
transliterates1462575transliterates
translocate1355535transloc_ate_
translocated1554425transloc_ated
transmittances18182755transmittances
transmutes1247305transmu___tes
transparency1992925transparenc_y
transpierce1554855trans_pierce_
transpierced1753515trans_pierced
transplacental1881775transplacental
transudates1246375trans_u_dates
transudes1047595trans_u___des
transuranics1463385trans_uranics
transverses1445905trans__verses
truculences1582625tr__uculences
tumescences1754155tumes__cences
turgescences1752845turges__cences

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 Filter1786911247900.390458182.1
2DLD Change Limit124790789.23313515.7
3Display Results78780.0501560.0
 (SQL Overall)178691789.67318473.2
 
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.