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

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

146 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
preconception215428(None) 
preconceptions2253881preconceptions
reconception1855641_reconception
preconvention2074002preconvention
reconceptions1965122_reconceptions
conception16410453___conception
misconception2163993misconception
postconception2282453postconception
preconcerting2084413preconcerting
precondition1755243precon_dition
preconviction2253703preconviction
reconnection1655993_reconnection
conceptions17410594___conceptions
decongestion1653924_decongestion
misconceptions2263574misconceptions
perception1688614p_e__rception
precancellation2161164precancellation
precognition1753884preco_gnition
precombustion2162244precombustion
preconceive2053354preconce__ive
preconceiving23102364preconceiving
preconcert16147974preconcert___
preconcerted1953864preconcert_ed
preconcerts17154504preconcert__s
preconditions1854894precon_ditions
preconvictions2353354preconvictions
premonition1547354premon__ition
preoccupation2152394pre_occupation
preoption1348084pre_o___ption
preponderation19103224preponderation
reception13410324_re___ception
recollection1654854_recollection
recondition1447124_recon_dition
reconnections1765754_reconnections
reconversion1754024_reconversion
reconviction1955084_reconviction
apperception1793465appe__rception
brecciation1744775brec__ciation
chemoreception2571825chemoreception
concepti14328275___concepti__
conceptional1856915___conceptional
conceptive1949515___conceptive
concertino14910845___concertino
concession14148135___concession
concoction1348235___concoction
concretion1449295___concretion
confection17411185___confection
congestion1349045___congestion
connection14410535___connection
conniption1446275___conniption
contention12412225___contention
convection17411125___convection
convention15410565___convention
deception1448325_de___ception
decoction1447525_deco_c__tion
decondition1545415_decon_dition
decongestions1753565_decongestions
disconnection1854205disconnection
exception2046855__e__xception
inception1348695____inception
misconnection1954135misconnection
nonconnection1784415nonconnection
perceptions1798195p_e__rceptions
percolation1549225perco__lation
personation1349485person__ation
photoreception2373785photoreception
postconvention2172125postconvention
precanceling1952775precance_ling
precancelling2051745precancelling
precaution1447245pre___caution
preceptive1947765pre___ceptive
preceptor1547325pre___cept_or
precession1448825pre___cession
precipitation1966225precipitation
precocities1748165preco_c_ities
precognitions1853595preco_gnitions
precombustions2262055precombustions
preconceived2252475preconce_ived
preconceives2152795preconce_ives
preconciliar1862145preconc_iliar
preconditioned2062415precon_ditioned
predication16412435pre_dic_ation
prediction15410305pre_dic__tion
predigestion1673825pre_digestion
predilection1754105pre_dilection
predomination1896535predomination
preelection15136485pre__election
preemption16105255pre___emption
preformation1946475prefo_rmation
preignition1454435preign__ition
preinduction1753785pre_induction
prelection141511295pre___lection
premonitions1646855premon__itions
premunition1545575premun__ition
prenomination17126755prenomination
prenotion1149175pre__n__otion
preoccupations2252015pre_occupations
preoptions1447645pre_o___ptions
preponderations20112875preponderations
preportion1448875prepo___rtion
preposition15108585prepo__sition
prepossession1762285prepossession
prerecession1683575pre_recession
prescription18145345pre_scription
preselection16154885pre_selection
presentation1448995presen_tation
presumption17154175pre__sumption
prevention1549175pre___vention
proaction13410105pr__oac__tion
procession1448415pr__o_cession
procreation1547955pr__ocreation
projection2158765pr__o_jection
prolongation1563715prolon_gation
pronation11415705pr__on__ation
pronunciation17113225pronunciation
proprioception19111995proprioception
proscription18124515pr__oscription
prosecution1546075pr__osecution
protection14511475pr__o_tection
protonation13510435proton__ation
provocation1847355provo_c_ation
recantation1349865_recan_tation
receptions1449745_re___ceptions
recognition1445205_reco_gnition
recollections1754725_recollections
reconceive1745295_reconce__ive
reconceiving2093455_reconceiving
reconcentration1963995_reconcentration
reconciliation1854125_reconciliation
reconditions1546825_recon_ditions
reconnecting1745355_reconnecting
reconsecration1885565_reconsecration
reconversions1853865_reconversions
reconverting1876405_reconverting
reconvictions2054875_reconvictions
recordation1449265_reco_rdation
recreation12413615_rec__reation
reinfection1645445_re_infection
reinjection2044585_re_injection
reinsertion1145445_re_insertion
reinvention1454515_re_invention
relocation12312115_relo_c_ation
renunciation1455315_renunciation
reoccupation1873325_re_occupation
resorption1247255_reso__rption
revocation15410815_revo_c_ation

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901468.86014084.7
3Display Results1461460.0931569.9
 (SQL Overall)1786911469.34319125.7
 
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.