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

69 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
transmutative186303(None) 
transmutation1554402transmutation
translative1456703trans__lative
transmutable1653013transmuta_ble
transmutations1653803transmutations
transformative2261924transformative
transitive1348494trans___itive
transmarine1357574transm__arine
transmissive1763444transm_issive
transmittable1762364transmittable
transmittance17143254transmittance
transmitting1556094transmit_ting
transmute1157184transmu__t__e
transmuting1456224transmu__ting
transudate1146744trans_udat__e
transudation1355324trans_udation
annotative1345035__an_notative
assortative1473955__assortative
commutative2055845__commutative
confutative1955445_con_futative
constative15410105_cons__tative
consultative1754785_consultative
consummative2164055_consummative
gravitative1852975gra__vitative
manipulative1952505_manipulative
mutative1348285_____mutative
nonimitative1784545_nonimitative
presentative1755345pr_esentative
quantitative2462085quan_titative
tentative1247815t_en___tative
transactinide16132105transactinide
transamination16103795transamination
transduction1584455transdu_ction
transfusable1752425transfusa_ble
transgressive1762195transgressive
transhumance1972545transhuma_nce
transistorise13143855transistorise
transistorize22143405transistorize
translatable1453055translata_ble
translate9412275trans__lat__e
translating1249445trans__lating
translation1149485trans__lation
translocate1355535translocat__e
translocating1654285translocating
translocation1554685translocation
transmigrate1554125transmigrat__e
transmigrating1863085transmigrating
transmigration17133385transmigration
transmittal1354005transmit_t_al
transmittals1453455transmit_tals
transmittances18182755transmittances
transmitted1485255transmit_t_ed
transmitter1395365transmit_t_er
transmitters1484395transmit_ters
transmontane1464075transm_ontane
transmountain1561845transmounta_i_n
transmuted1345595transmu__t_ed
transmutes1247305transmu__t_es
transpiration1555425transpiration
transpontine1465135trans_pontine
transportation1663295transportation
transudates1246375trans_udat_es
transudations1454835trans_udations
transuranic1354105trans_urani_c
transuranics1463385trans_uranics
transuranium1462795trans_uranium
transvestite1553925trans_vestite
traumatise1295415tra___umatise
traumatize2155685tra___umatize

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 Limit124790699.15613629.3
3Display Results69690.0461500.0
 (SQL Overall)178691699.59218629.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.