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

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

174 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
transpirations165472(None) 
transpiration1555421transpiration_
transmigrations18132962transmigrations
transpirational1773102transpirational
transportations1762902transportations
aspirations1348993__a_spirations
conspirations1747723_conspirations
inspirations1447303__inspirations
respirations14410303_r_espirations
transaminations17113423transaminations
transcriptions1863633transcriptions
transformations2062823transformations
transitions1148923trans_i__tions
translations1258373trans__lations
translocations1664233translocations
transmigration17133383transmigration_
transmutations1653803transmutations
transportation1663293transportation_
transpositions1663673transpositions
transudations1454833trans_udations
aspiration1249994__a_spiration_
conspiration1648384_conspiration_
exasperations2253694exa_sperations
haruspications2151624haruspications
inspiration1348374__inspiration_
perspirations1786174_perspirations
respiration13511194_r_espiration_
suspirations1445854__suspirations
transactions1445884trans__actions
transamination16103794transamination_
transcription1764074transcription_
transductions1664294trans_ductions
transections1446764trans__ections
transfections1854854trans_fections
transfiguration1962224transfiguration_
transfixions2253934transfi__xions
transformation1963074transformation_
transition1049704trans_i__tion_
translation1149484trans__lation_
transliteration1562124transliteration_
translocation1554684translocation_
transmigrating1863084transmigrati_ng
transmigrators1762224transmigrat_ors
transmissions1554124transmi_ssions
transmutation1554404transmutation_
transpiring1446874transpir__i_ng
transporting1555784transpor_ti_ng
transposition1554184transposition_
transudation1355324trans_udation_
transvaluations1863024transvaluations
trepidations1554934tr__epidations
admirations1446695__a_dmirations
aestivations1547485__aestivations
animations12312195__an__imations
anodizations2276925__anodizations
arabicizations2753905arabicizations
aspirating1348365__a_spirati_ng
aspirational1455005__a_spirational
aspirators1247005__a_spirat_ors
brachiations19193525bra_chi_ations
canalizations24410435_canalizations
canonizations2447245_canonizations
capitations1549855_ca__pitations
castigations1547205_ca_stigations
castrations13410055_ca_s_trations
consecrations1749215_consecrations
conspirational1853965_conspirational
conspirators1655535_conspirat_ors
constipations1747685_constipations
crepitations1647475cr__epitations
cuspidations1743345__cuspidations
desperations1559525__desperations
dramatisations1772795dramatisations
dramatizations2675715dramatizations
emancipations1953745eman_cipations
eradications1549305era__dications
evaporations1744695eva__porations
exasperation2154025exa_speration_
expirations2069585___expirations
fasciations1646265_fa_sci_ations
fascinations1746375_fa_scinations
frustrations1544535fr_us_trations
granulations1345785gran__ulations
gratifications2045985gratifications
gravitations1644765gra__vitations
haruspication2051605haruspication_
inspirational1554415__inspirational
inspirators1345555__inspirat_ors
inspissations1552045__inspissations
instigations1348245__instigations
manipulations1754115_manipulations
mastications1649415_ma_stications
mensurations1445715_mens_urations
organisations1473355organ__isations
organizations2386605organ__izations
palpitations1645525_pa_lpitations
passivations1764435_pa_ssivations
perspiration1656835_perspiration_
precipitations2085395precipitations
prenominations18105765prenominations
preparations1648315pr__eparations
prostrations1449765pr_os_trations
quantitations2263365quan_titations
quantizations3164575quan_tizations
racemizations2665475_racemizations
radiations11311925_ra__di_ations
ramifications2087535_ramifications
randomizations2653685_randomizations
ratifications1899785_ratifications
reanimations1468785rean__imations
recuperations1746085_recuperations
renaturations1355965_renaturations
renominations15108305_renominations
reoperations14410065_r_eoperations
reparations13611665_r__eparations
respirators1375445_r_espirat_ors
restorations12410955_r_estorations
retranslations1454215retrans__lations
rustications1448565_r_ustications
sanitations11410845_san__itations
sanitizations2248555_sanitizations
strangulations1563655stran_gulations
stratifications2054235stratifications
suspiration1346545__suspiration_
tarnations1038905tarn____ations
tetanizations2249915tetan__izations
trabeations1345375tra___beations
traditions1147195tra__di__tions
transaction1346305trans__action_
transcriptional1992245transcriptional
transduction1584455trans_duction_
transection1357375trans__ection_
transfection1765395trans_fection_
transferrins1554585transfer_ri_ns
transfixion2154205transfi__xion_
transfusions1553935trans__fusions
transgressions15102295transgressions
transistors1155745trans_i_st_ors
transiting11410775trans_i__ti_ng
transitional1256225trans_i__tional
translating1249445trans__lati_ng
translational1354745trans__lational
translators1156445trans__lat_ors
transliterating1691865transliterati_ng
translocating1654285translocati_ng
transmigrates1663845transmigrat__es
transmigrator1662675transmigrat_o_r
transmigratory2071715transmigrat_ory
transmission1454595transmi_ssion_
transmitting1556095transmi_tti_ng
transnational1353915trans__national
transparentizes2672025transparentizes
transpicuous1662195transpi__cuous
transpiercing1862845transpierci_ng
transpires1249315transpir____es
transplantation1771875transplantation_
transplanting1663965transplanti_ng
transpontine1465135transp_onti_ne
transporters1454815transpor_t_ers
transports1247575transpor_t___s
transpositional17112335transpositional
transposons1354585transp___osons
transuranics1463385trans_urani_cs
transvaluation1763365transvaluation_
traumatizations2653655traumatizations
trepanations1444575tr__epanations
trephinations1853555tr_ephinations
trepidation1445495tr__epidation_
triangulations1552315trian_gulations
triplications1795075tr_iplications
triturations1245685tr__iturations
truncations1344765trun___cations
urbanisations1552855urban__isations
urbanizations2445955urban__izations

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 Filter178691950240.373479064.3
2DLD Change Limit950241747.19013216.1
3Display Results1741740.1101581.8
 (SQL Overall)1786911747.67323288.3
 
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.