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

49 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
transliterated156208(None) 
transliterate1363091transliterate_
transliterates1462571transliterates
transliterating1691863transliterating
transliteration1562123transliteration
transmigrated1773203transmi_grated
alliterated1294704__a_lliterated
translated1149294transl____ated
translocated1554424transl__ocated
transmigrate1554124transmi_grate_
transmigrates1663844transmi_grates
transmitted1485254transmit___ted
transpierced1753514transpi_er_ced
adulterated1353505__adul_terated
aliterate91611345__a__literate_
aliterates101510765__a__literates
alliterate1086635__a_lliterate_
alliterates11106265__a_lliterates
antiliterate1254105__antiliterate_
nonliterate1156195_non_literate_
nonliterates1255455_non_literates
obliterated1453825___obliterated
preliterate1365955pr__eliterate_
preliterates1455345pr__eliterates
proliferated1852365pr__oliferated
reiterated11410155_r___eiterated
transected1347315trans___e_cted
transfected1745355trans__fe_cted
transferase1455455trans__ferase_
transferases1555085trans__ferases
transferred1554605trans__fer_red
transfigured1752455transfigur__ed
transistorised15142845transistorised
transistorized24142885transistorized
transited10410605trans_i____ted
translate9412275transl____ate_
translates10411705transl____ates
translocate1355535transl__ocate_
translocates1455395transl__ocates
transmigrator1662675transmi_grator
transmitter1395365transmit___ter
transpierce1554855transpi_er_ce_
transpierces1654685transpi_er_ces
transpired1346765transpi__r__ed
transported1455835trans__por_ted
transvaluated17112785trans_valuated
triturated1145075tr____iturated
unadulterated1561755unadul_terated
unliberated1444255__un_liberated

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.360496363.9
2DLD Change Limit95024496.87613819.7
3Display Results49490.0301633.3
 (SQL Overall)178691497.26624592.8
 
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.