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

70 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
transformation196307(None) 
transformations2062821transformations
transformative2261922transformative
transportation1663292transportation
translocation1554683translo_cation
transpiration1555423transpir_ation
transportations1762903transportations
conformation1947324_con_formation
information16147714__in_formation
malformation1953324_ma_lformation
preformation1946474pr__eformation
reformation1648414_r__eformation
transamination16103794transamination
transcription1764074trans_cription
transfection1765394transf__ection
transfiguration1962224transfiguration
transformable2072274transforma_ble
transforming1854644transform__ing
translation1149484trans___lation
translocations1664234translo_cations
transmigration17133384transmigration
transmutation1554404trans_mutation
transpirations1654724transpir_ations
transposition1554184transpo_sition
transudation1355324trans__udation
transvaluation1763364transvaluation
affirmation1953685__a_ffirmation
confirmation1946185_con_firmation
conformations2046725_con_formations
deformation1747665___deformation
disinformation2063335disinformation
formation1439425_____formation
informations17127035__in_formations
malformations2053075_ma_lformations
misinformation2172595misinformation
noninformation1973315noninformation
preformations2045715pr__eformations
reaffirmation2152065_reaffirmation
reformations1747605_r__eformations
restoration11412095_r_estor_ation
transaction1346305trans___action
transaminations17113425transaminations
transcriptions1863635trans_criptions
transduction1584455trans__duction
transection1357375trans___ection
transfections1854855transf__ections
transferential1762565transferential
transferrin1454775transfer__ri_n
transfixion2154205transf___ixion
transform1446195transform_____
transformed1754755transform___ed
transformer1654875transform___er
transformers1753755transform__ers
transforms1545835transform____s
transfusion1454235transf___usion
transgression1462695trans_gression
transition1049705trans____ition
translations1258375trans___lations
transliteration1562125transliteration
translocating1654285translo_cating
transmigrations18132965transmigrations
transmountain1561845transmountai_n
transmutations1653805trans_mutations
transpirational1773105transpir_ational
transplantation1771875transplantation
transporting1555785transpor__ting
transpositions1663675transpo_sitions
transudations1454835trans__udations
transvaluations1863025transvaluations
trifurcation1753275tr__ifurcation

Search took 7 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 Limit95024706.18615361.1
3Display Results70700.0631111.1
 (SQL Overall)178691706.60927037.5
 
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.