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

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

100 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
congressionally2172131congressionally_
confessionally22103513con_fessionally_
congressional1653513congressiona_l__
compressional1954265compressiona_l__
concessional16195395con_cessiona_l__
concessionary2072935con_cessiona_ry_
confessional17175465con_fessiona_l__
confessionalism2272435con_fessionalism
confessionalist2072525con_fessionalist
confessionals18154175con_fessiona_l_s
conventionally2254985con_ventionally_
obsessionally1862385_o_bsessionally_
collisionally1862116co__llisionally_
concessionaire18142436con_cessiona_ire
concessionaires19171946con_cessionaires
concretionary2062866concre_tiona_ry_
conditionally1954796con__ditionally_
congenially1755906cong_e_ni__ally_
congenitally1854396cong_e_ni_tally_
congregational1863436congregationa_l__
congressing1545606congressi_n____g
congresswoman2171056congresswoma___n
conjugationally2862356conjugationally_
conjunctionally2972486conjunctionally_
conversional1755146con_versiona_l__
digressional1453176_digressiona_l__
digressionary1861576_digressiona_ry_
intensionally1654396_in_tensionally_
processionally2163136_processionally_
professionally2263186_professionally_
progressional1663966progressiona_l__
successionally2161446_successionally_
torsionally1453876to__r__sionally_
bidirectionally2371517bidirectionally_
caressingly1752957c__aressi_n_gly_
coeducationally23102357coeducationally_
coloristically2164837coloristi_cally_
compassionately2471867co_mpassionately_
compositionally2462287compositionally_
compression1756567compression_____
compressions1856407compression____s
compressively25103387compressi__vely_
computationally2462497computationally_
conceptional1856917con_ceptiona_l__
concession14148137con_cession_____
concessioner1653677con_cession___er
concessioners1753067con_cession__ers
concessions15128107con_cession____s
concessively22134237con_cessi__vely_
conclusionary2062107con_clusiona_ry_
confectionary2353777con_fectiona_ry_
confession15126507con_fession_____
confessions16136637con_fession____s
confusional1654247con__fusiona_l__
congestion1349047cong_estion_____
congestions1449317cong_estion____s
congressman1651887congress__ma___n
congressmen1652807congressmen_____
congresspeople217677congress_peopl_e
congresswomen216927congresswo___men
connectional1646727con_nectiona_l__
conscionable1853627con___scionabl_e
consensually1753167con_sens__ually_
contractional1756067contractiona_l__
contractionary2162717contractiona_ry_
controversially2381497controversi__ally_
convectional1947047con_vectiona_l__
conventional1757167con_ventiona_l__
conventionalism22133157con_ventionalism
conventionalist20123537con_ventionalist
conventionality2393047con_ventionality
conventionalize29102737con_ventionalize
conversational1954167conversationa_l__
convulsionary21101897con_vulsiona_ry_
coronally1448417co__r____onally_
correctional1675327co_rrectiona_l__
dimensionally1962357__dimensionally_
engrossingly1751417_engrossi_n_gly_
erosionally1454667___er_osionally_
expressional2164217_expressiona_l__
extensionally2362887__extensionally_
forensically2054127fo__rensi_cally_
generationally1883007gener_ationally_
impressionable2062377_impressionabl_e
inflectionally2262957_inflectionally_
ingression1145517_ingression_____
ingressions1245497_ingression____s
intentionally1655987_in_tentionally_
intestinally1556017_in_testi_nally_
longitudinally197977longitudi_nally_
nonfissionable1962217non_fissionabl_e
nonprofessional2072137nonprofessiona_l__
nonsensically1853187non_sensi_cally_
obsessional1353347_o_bsessiona_l__
occasionally1952757_o__ccasionally_
operationally1854647_oper_ationally_
possessional1463647po_ssessiona_l__
regionally1445537____re_gionally_
unquestionably2862837_unquestionably_
unreasonably1753897_un_reas_onably_

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.343520965.0
2DLD Change Limit950241008.18611608.1
3Display Results1001000.0801250.0
 (SQL Overall)1786911008.60920756.3
 
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.