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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
transmarine135757(None) 
transalpine1365033transalpine
transcribe1446813trans_cribe
translating1249443translating
translative1456703translative
transmuting1456223transmuting
transparence1694103transparence
transparent1356713transparent
transpiring1446873transpiring
anserine8313094__ans_erine
tamarin9311924t_a__marin_
tamarind1147024t_a__marind
tamarins10310844t_a__marins
tangerine1048404t_an_gerine
trademarking2052024trademarking
tramline10311384tra__m_line
transacting1446524transacting
transaminase1453374trans_aminase
transaxle1645914trans_a_xle
transcribed1654744trans_cribed
transcriber1554784trans_criber
transcribes1556174trans_cribes
transcript1456474trans_cript
transducing1554354transducing
transecting1447374transecting
transferase1455454transferase
transferee1347254transfer_ee
transference1754314transference
transferrin1454774transferrin_
transferring1654334transferring
transferrins1554584transferrins
transfinite1455504transfinite
transfixing2254804transfixing
transforming1854644transforming
transfusing1554674transfusing
transgene1047954trans__gene
transiting11410774trans_iting
transitive1348494trans_itive
translate9412274transla__te
translation1149484translation
translations1258374translations
transmembrane1971564transmembrane
transmigrate1554124transmigrate
transmissive1763444transmissive
transmit10410914transm__i_t
transmits1149274transm__its
transmitting1556094transmitting
transmogrify2161944transmogrify
transmontane1464074transmontane
transmutative1863034transmutative
transmute1157184transm__ute
transparences17103754transparences
transparency1992924transparency
transpire1148864trans__pire
transpontine1465134transpontine
transporting1555784transporting
transposing1455454transposing
transshaping1863494transshaping
transuding1246004trans_uding
transuranic1354104transuranic
transvalue1353944transva_lue
transvaluing1653424transvaluing
transverse1345904transver_se
traumatise1295414tra_umatise
traumatize2155684tra_umatize
ultramarine1354804ultra__marine

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 Filter1786911488190.423422437.4
2DLD Change Limit148819668.37317773.7
3Display Results66660.0332000.0
 (SQL Overall)178691668.82920239.1
 
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.