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

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

115 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
transfiguration196222(None) 
transmigration17133382transmig_ration
transliteration1562123transliteration
transmigrations18132963transmig_rations
transpiration1555423transpi__ration
configuration1954134_con_figuration
prefiguration1953454pr__efiguration
transfiguring1862684transfigur__ing
transformation1963074transf_ormation
transmigrating1863084transmig_rating
transmigrator1662674transmig_rat_or
transmutation1554404trans__mutation
transpirations1654724transpi__rations
transudation1355324trans___udation
transvaluation1763364transvalu_ation
configurations2063705_con_figurations
figuration1445915_____figuration
prefigurations2053025pr__efigurations
reconfiguration2162055reconfiguration
strangulation1464045stran___gulation
transamination16103795trans_amination
transduction1584455trans__du_ction
transfection1765395transf___ection
transfigure1553435transfigur____e
transfigured1752455transfigur___ed
transfigures1653255transfigur___es
transfixion2154205transfi____xion
transformations2062825transf_ormations
transfusion1454235transf__u__sion
transition1049705trans_i____tion
translation1149485trans____lation
transliterating1691865transliterating
translocation1554685trans__location
transmigrate1554125transmig_rat__e
transmigrated1773205transmig_rat_ed
transmigrates1663845transmig_rat_es
transmigrators1762225transmig_rators
transmigratory2071715transmig_ratory
transmutations1653805trans__mutations
transpirational1773105transpi__rational
transplantation1771875transplantation
transportation1663295trans_portation
transudations1454835trans___udations
transvaluations1863025transvalu_ations
triangulation1452705trian___gulation
trituration1146655tr____ituration
angulation1149556__an___gulation
antiquation2047426__an_tiqu_ation
aspiration1249996__a_spi__ration
assignation1244376__a_ssig_nation
castigation1447976_ca_stig__ation
configurational2162206_con_figurational
configurative2262816_con_figurative
consideration1655526_cons_ideration
consignation15136316_cons_ig_nation
conspiration1648386_conspi__ration
denigration1348466_den__ig_ration
fasciculation20133566_fa_sciculation
figurations1545086_____figurations
granulation1246556gran____ulation
gratification1946686gratifi__cation
inauguration1353706__in_auguration
infiltration1554526__in_filtration
insinuation11137266__ins_inu_ation
inspiration1348376__inspi__ration
instauration12114836__ins_tauration
instigation1249246__instig__ation
invigoration1654596__in_vigoration
manipulation1654666_man__ipulation
mensuration1346496_mens___uration
nonfigurative2062826_non_figurative
prefigurative2262076pr__efigurative
premigration1755696pr__emig_ration
ramification1998216_ramifi__cation
ratification17810666_ratifi__cation
refrigeration1764156_r_efrigeration
reinvigoration18152716_reinvigoration
remigration14228916_r__emig_ration
renaturation1256756_ren__aturation
resignation1247476_r_es_ig_nation
respiration13511196_r_espi__ration
restimulation1555376_r_estimulation
strangulations1563656stran___gulations
stratification1954676stratifi__cation
transaction1346306trans____action
transaminations17113426trans_aminations
transcription1764076trans__cription
transductions1664296trans__du_ctions
transection1357376trans____ection
transfections1854856transf___ections
transferrin1454776transf__er_ri_n
transfixions2253936transfi____xions
transformative2261926transf_ormative
transfusions1553936transf__u__sions
transgression1462696trans__gression
transitions1148926trans_i____tions
translations1258376trans____lations
transliterate1363096transliterat__e
transliterated1562086transliterat_ed
transliterates1462576transliterat_es
translocations1664236trans__locations
transmission1454596transmi___ssion
transmountain1561846trans_mountai_n
transmutative1863036trans__mutative
transportations1762906trans_portations
transposition1554186trans__position
transuranic1354096trans___urani_c
transuranics1463386trans___uranics
transuranium1462786trans___uranium
transvaluating1862736transvalu_ating
triangulations1552316trian___gulations
tribulation1346496tr____ibulation
trifurcation1753276tr____ifurcation
triturations1245686tr____iturations
ultrafiltration1881266ultra__filtration

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 Filter178691950240.360496363.9
2DLD Change Limit950241157.65312416.6
3Display Results1151150.0801437.5
 (SQL Overall)1786911158.09322079.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.