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

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
transmigrations18132961transmigrations_
transmigration17133382transmigration__
transmigrating1863073transmigrati_n_g
transmigrators1762223transmigrat_ors_
transpirations1654723transpi_rations_
transaminations17113424transami_nations_
transfiguration1962224transfiguration__
transmigrates1663844transmigrat__es_
transmigrator1662674transmigrat_o__r
transmigratory2071714transmigrat_o_ry
transmutations1653794transm_utations_
transpiration1555424transpi_ration__
transpirational1773094transpi_rational
remigrations15227795_r__emigrations_
transamination16103795transami_nation__
transformations2062825transformations_
transitions1148915trans_i___tions_
translations1258345trans___lations_
transliteration1562115transliteration__
translocations1664235trans_locations_
transmigrate1554125transmigrat____e
transmigrated1773205transmigrat___ed
transmissions1554115transmi__ssions_
transmutation1554395transm_utation__
transportations1762905transportations_
transudations1454835trans__udations_
transvaluations1863025transvaluations_
admirations1446696__a_dmi_rations_
aspirations1348996__a_spi_rations_
assignations1344156__a_ssignations_
castigations1547206_ca_stig_ations_
consignations16105936_cons_ignations_
conspirations1747716_conspi_rations_
denigrations1447356_den__igrations_
emigrations14187156____emigrations_
immigrations1743726___immigrations_
inspirations1447296__inspi_rations_
instigations1348246__instig_ations_
migrations13168676_____migrations_
premigration1755696pr__emigration__
prenominations18105766prenomi_nations_
racemizations2665466_racemi_zations_
randomizations2653676_randomi_zations_
remigration14228916_r__emigration__
renominations15108296_renomi_nations_
resignations1346876_r_es_ignations_
respirations14410306_r_espi_rations_
transactions1445876trans___actions_
transcriptions1863636trans_criptions_
transductions1664296trans__ductions_
transections1446756trans___ections_
transfections1854856trans__fections_
transfixions2253936transfi___xions_
transformation1963076transformation__
transgressions15102296trans__gressions_
transition1049696trans_i___tion__
transitional1256196trans_i___tional
translation1149476trans___lation__
translational1354736trans___lational
transliterating1691856transliterati_n_g
translocation1554686trans_location__
transmission1454586transmi__ssion__
transmitting1556086transmi__tti_n_g
transmogrifies2071596transmogrifi_es_
transnational1353906trans___national
transportation1663296transportation__
transpositions1663656trans_positions_
transudation1355326trans__udation__
transvaluation1763366transvaluation__

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 Filter178691658740.0931921408.6
2DLD Change Limit65874696.9539474.2
3Display Results69690.110627.3
 (SQL Overall)178691697.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.