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

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

64 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
transliteration1562121transliteration_
transliterating1691862transliterati_ng
transfiguration1962224transfiguration_
transliterate1363094transliterat___e
transliterated1562084transliterat__ed
transliterates1462574transliterat__es
transmigration17133384transmi_gration_
transmigrations18132964transmi_grations
transpiration1555424transpi__ration_
transpirational1773104transpi__rational
transpirations1654724transpi__rations
alliteration1285165__a_lliteration_
alliterations1384555__a_lliterations
translation1149485transl____ation_
translational1354745transl____ational
translations1258375transl____ations
translocation1554685transl__ocation_
translocations1664235transl__ocations
transmigrating1863085transmi_grati_ng
transmutation1554405transmut__ation_
transmutations1653805transmut__ations
adulteration1353666__adul_teration_
adulterations1453176__adul_terations
alliterating1354276__a_lliterati_ng
alteration10612906__a__l_teration_
alterations11511666__a__l_terations
consideration1655526_cons_ideration_
considerations1764846_cons_iderations
literation10511416_____literation_
literations11610586_____literations
obliteration1453896___obliteration_
obliterations1553456___obliterations
proliferation1853036pr__oliferation_
proliferations1952706pr__oliferations
reiteration11412166_r___eiteration_
reiterations12410876_r___eiterations
transamination16103796trans_amination_
transaminations17113426trans_aminations
transection1357376trans___e_ction_
transections1446766trans___e_ctions
transfection1765396trans__fe_ction_
transfections1854856trans__fe_ctions
transformation1963076trans_formation_
transformations2062826trans_formations
transition1049706trans_i____tion_
transitional1256226trans_i____tional
transitions1148926trans_i____tions
translating1249446transl____ati_ng
translocating1654286transl__ocati_ng
transmigrator1662676transmi_grat_o_r
transmigrators1762226transmi_grat_ors
transmigratory2071716transmi_grat_ory
transmitting1556096transmit___ti_ng
transnational1353916trans____national
transpiercing1862846transpi_er_ci_ng
transplantation1771876transplantation_
transportation1663296trans_portation_
transportations1762906trans_portations
transudation1355326trans___udation_
transudations1454836trans___udations
transvaluation1763366trans_valuation_
transvaluations1863026trans_valuations
trituration1146656tr____ituration_
triturations1245686tr____iturations

Search took 6 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 Filter178691658740.330541487.9
2DLD Change Limit65874645.17012741.6
3Display Results64640.0501280.0
 (SQL Overall)178691645.55032196.6
 
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.