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

59 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
transhumances207228(None) 
transhumance1972541transhumance_
transhumants1762892transhuman_ts
transhumant1654083transhuman__t
translucences1793573translucences
transduces1345604transdu___ces
transferences1853684transferences
transiences13128274trans__iences
translucence16113964translucence_
translucencies1862224translucencies
transmittances18182754transmittances
transparences17103754transparences
transudates1246374trans_uda_tes
transuranics1463384trans_uranics
assurances1244695__a_ssurances
coinsurances1653015coins_urances
insurances1246865__ins_urances
intransigeances18131765intransigeances
reassurances14112605_reassurances
reinsurances1452815reins_urances
transacts1157365trans___a_cts
transaminase1453375trans_aminase
transaminases1562985trans_aminases
transaxles1745065trans___axles
transcendences1962215transcendences
transcutaneous1671015transcutaneous
transduce1245215transdu___ce_
transduced1444235transdu___ced
transducer1354455transdu___cer
transducers1453585transdu___cers
transductants1672545transductan_ts
transferases1555085transfera_ses
transference1754315transference_
transfusable1752425transfusable_
transfuses1346745transfu___ses
transgenes1148405trans__gen_es
transience12128435trans__ience_
transiencies1456005trans__iencies
translates10411705trans__la_tes
translocates1455395transloca_tes
translucency19132795translucenc_y
transmittance17143255transmittance_
transmutable1653015transmutable_
transmutes1247305trans__m_utes
transparence1694105transparence_
transparencies1892725transparencies
transpierces1654685trans_pierces
transplanted1574525trans_planted
transplanter1474565trans_planter
transplanters1583065trans_planters
transplants1355815trans_plan_ts
transshapes1674315trans_sha_pes
transudate1146745trans_uda_te_
transudes1047595trans_u___des
transuranic1354105trans_uran_ic
transuranium1462785trans_uranium
transvalues1454075trans__values
trashman1345815tra_sh_man___
trenchancies1952525trench__ancies

Search took 9 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.373479064.3
2DLD Change Limit124790598.11015387.2
3Display Results59590.0331787.9
 (SQL Overall)178691598.51620983.0
 
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.