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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

183 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
transfiguration1962221transfiguration_
transmigration17133383transmig_ration_
transmigrations18132963transmig_rations
transfiguring1862684transfigur__i_ng
transliteration1562124transliteration_
transmigrating1863084transmig_rati_ng
transpiration1555424transpi__ration_
transpirational1773104transpi__rational
transpirations1654724transpi__rations
configuration1954135_con_figuration_
configurational2162205_con_figurational
configurations2063705_con_figurations
prefiguration1953455pr__efiguration_
prefigurations2053025pr__efigurations
transformation1963075transf_ormation_
transformations2062825transf_ormations
transliterating1691865transliterati_ng
transmigrator1662675transmig_rat_o_r
transmigrators1762225transmig_rat_ors
transmigratory2071715transmig_rat_ory
transmutation1554405trans__mutation_
transmutations1653805trans__mutations
transudation1355325trans___udation_
transudations1454835trans___udations
transvaluation1763365transvalu_ation_
transvaluations1863025transvalu_ations
figuration1445916_____figuration_
figurations1545086_____figurations
reconfiguration2162056reconfiguration_
strangulation1464046stran___gulation_
strangulations1563656stran___gulations
transamination16103796trans_amination_
transaminations17113426trans_aminations
transduction1584456trans__du_ction_
transductional1782516trans__du_ctional
transductions1664296trans__du_ctions
transfection1765396transf___ection_
transfections1854856transf___ections
transfigure1553436transfigur_____e
transfigured1752456transfigur____ed
transfigures1653256transfigur____es
transfixion2154206transfi____xion_
transfixions2253936transfi____xions
transfusion1454236transf__u__sion_
transfusional1662416transf__u__sional
transfusions1553936transf__u__sions
transition1049706trans_i____tion_
transitional1256226trans_i____tional
transitions1148926trans_i____tions
translation1149486trans____lation_
translational1354746trans____lational
translations1258376trans____lations
translocation1554686trans__location_
translocations1664236trans__locations
transmigrate1554126transmig_rat___e
transmigrated1773206transmig_rat__ed
transmigrates1663846transmig_rat__es
transnational1353916trans____national
transplantation1771876transplantation_
transportation1663296trans_portation_
transportations1762906trans_portations
transvaluating1862736transvalu_ati_ng
triangulation1452706trian___gulation_
triangulations1552316trian___gulations
trituration1146656tr____ituration_
triturations1245686tr____iturations
angulation1149557__an___gulation_
angulations1268057__an___gulations
antiquation2047427__an_tiqu_ation_
antiquations2146257__an_tiqu_ations
antirational1278497__an_ti__rational
aspiration1249997__a_spi__ration_
aspirational1455007__a_spi__rational
aspirations1348997__a_spi__rations
assignation1244377__a_ssig_nation_
assignations1344167__a_ssig_nations
castigation1447977_ca_stig__ation_
castigations1547207_ca_stig__ations
configurative2262817_con_figurati_ve
consideration1655527_cons_ideration_
considerations1764847_cons_iderations
consignation15136317_cons_ig_nation_
consignations16105937_cons_ig_nations
conspiration1648387_conspi__ration_
conspirational1853967_conspi__rational
conspirations1747727_conspi__rations
denigration1348467_den__ig_ration_
denigrations1447357_den__ig_rations
fasciculation20133567_fa_sciculation_
fasciculations21133097_fa_sciculations
granulation1246557gran____ulation_
granulations1345787gran____ulations
gratification1946687gratifi__cation_
gratifications2045987gratifi__cations
inauguration1353707__in_auguration_
inaugurations1453157__in_augurations
infiltration1554527__in_filtration_
infiltrations1653907__in_filtrations
insinuation11137267__ins_inu_ation_
insinuations12136427__ins_inu_ations
inspiration1348377__inspi__ration_
inspirational1554417__inspi__rational
inspirations1447307__inspi__rations
instauration12114837__ins_tauration_
instaurations13114257__ins_taurations
instigation1249247__instig__ation_
instigations1348247__instig__ations
invigoration1654597__in_vigoration_
invigorations1753917__in_vigorations
manipulation1654667_man__ipulation_
manipulations1754117_man__ipulations
mensuration1346497_mens___uration_
mensurations1445717_mens___urations
nonfigurative2062827_non_figurati_ve
prefigurative2262077pr__efigurati_ve
premigration1755697pr__emig_ration_
ramification1998217_ramifi__cation_
ramifications2087537_ramifi__cations
ratification17810667_ratifi__cation_
ratifications1899787_ratifi__cations
refrigeration1764157_r_efrigeration_
refrigerations1863777_r_efrigerations
reinvigoration18152717_reinvigoration_
reinvigorations19152417_reinvigorations
remigration14228917_r__emig_ration_
remigrations15227797_r__emig_rations
renaturation1256757_ren__aturation_
renaturations1355967_ren__aturations
resignation1247477_r_es_ig_nation_
resignations1346887_r_es_ig_nations
respiration13511197_r_espi__ration_
respirations14410307_r_espi__rations
restimulation1555387_r_estimulation_
restimulations1654647_r_estimulations
strangulating1583267stran___gulati_ng
stratification1954677stratifi__cation_
stratifications2054237stratifi__cations
transaction1346307trans____action_
transactional1553427trans____actional
transactions1445887trans____actions
transcription1764077trans__cription_
transcriptional1992247trans__criptional
transcriptions1863637trans__criptions
transection1357377trans____ection_
transections1446767trans____ections
transfecting1855167transf___ecti_ng
transferrin1454777transf__er_ri_n_
transferring1654337transf__er_ri_ng
transferrins1554587transf__er_ri_ns
transfixing2254807transfi____xi_ng
transformative2261927transf_ormati_ve
transforming1854647transf__or_mi_ng
transfusing1554677transf__u__si_ng
transgression1462697trans__gression_
transgressions15102297trans__gressions
transiting11410777trans_i____ti_ng
translating1249447trans____lati_ng
transliterate1363097transliterat___e
transliterated1562087transliterat__ed
transliterates1462577transliterat__es
translocating1654287trans__locati_ng
transmission1454597transmi___ssion_
transmissions1554127transmi___ssions
transmitting1556097transmi___tti_ng
transmountain1561847trans_mountai_n_
transmutative1863037trans__mutati_ve
transmuting1456227trans__mu__ti_ng
transpiercing1862847transpi_er_ci_ng
transpiring1446877transpi__r__i_ng
transporting1555787trans__por_ti_ng
transposition1554187trans__position_
transpositional17112337trans__positional
transpositions1663677trans__positions
transuranic1354107trans___urani__c
transuranics1463387trans___urani_cs
transuranium1462797trans___urani_um
triangulating1562357trian___gulati_ng
tribulation1346497tr____ibulation_
tribulations1445467tr____ibulations
trifurcation1753277tr____ifurcation_
trifurcations1852867tr____ifurcations
triturating1245437tr____iturati_ng
ultrafiltration1881267ultra__filtration_

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 Filter178691950240.360496363.9
2DLD Change Limit950241837.83012135.9
3Display Results1831830.1561173.1
 (SQL Overall)1786911838.34621410.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.