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

70 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
abortifacient20133374(None) 
abortifacients211803441abortifacients
somnifacient1961534_somnifacient
abortionist1356165aborti_oni_st
amortization2347205amortization_
amortizations2456465amortizations
artifact1346145a__rtifac___t
somnifacients206785_somnifacients
abolishment18104246abo_li_shment
abominating1644846abo_minati_ng
abomination1547486abo_mination_
abominations1646616abo_minations
aborigine1244776abor_i__gi_ne
aborigines1343506abor_i__gines
aborting11710256abort____i_ng
abortion1048106abort____ion_
abortionists1454976aborti_onists
abortions1147786abort____ions
abortive1346886aborti___ve__
abortively1844346aborti___vely
abortiveness1755326aborti_veness
abridgement1753376ab_r_idgement
abridgment1653516ab_r_i_dgment
abstinent1145926ab_sti___nent
abstractest1553626ab_st_ractest
amortising1345976amorti__si_ng
amortizable2452376amortizable__
amortizing2246406amorti__zi_ng
antialien9410176a__nti_alien_
antifascist1654336a__ntifasci_st
antiracist12410686a__ntiraci_st
apostacies1445606apost__acie_s
apportionment19102476apporti_onment
arborescent1553406arbor__esc_ent
arborization2347886arbor_ization_
arborizations2447426arbor_izations
artefact1345186a__rtefac___t
artifacts1443416a__rtifac__ts
artifactual1691596a__rtifactual
artifice1346406a__rtific_e__
artificer1444026a__rtific_e_r
artificers1543496a__rtific_ers
artifices1446476a__rtific_e_s
artificial1553926a__rtifici_al
boldfacing1951486_bo_ldfaci_ng
boniface1543866_bo_nifac_e__
bonifaces1643736_bo_nifac_e_s
coefficient2182786_co_efficient
fortified1646506_fortif__ie_d
fortifier1546256_fortif__ie_r
fortifiers1644536_fortif__iers
fortifies1548696_fortif__ie_s
fortifying2045156_fortif_yi_ng
mortician1346996_morti__cian_
morticians1445706_morti__cians
morticing1448016_morti__ci_ng
mortified1547386_mortif__ie_d
mortifier1446926_mortif__ie_r
mortifiers1544396_mortif__iers
mortifies1439396_mortif__ie_s
mortifying1944926_mortif_yi_ng
obstinacies1572276ob_stinacie_s
omnificent1753036__omnific_ent
omniscient1453616__omni_scient
ordinariest1253326__ordinariest
outfacing1578116__out_faci_ng
outpatient1254066__out_patient
proficient1756246__pr_oficient
rubefacient18182136__rubefacient
vorticist1448166_vorti__ci_st

Search took 19 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 Filter1786911488190.423422437.4
2DLD Change Limit1488197017.8308346.6
3Display Results70700.0461521.7
 (SQL Overall)1786917018.2999765.1
 
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.