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

37 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
abortifacients21180344(None) 
abortifacient201333741abortifacient_
somnifacients206784_somnifacients
abortionists1454995aborti_oni_sts
amortizations2456465amortization_s
artifacts1443415a__rtifac___ts
somnifacient1961535_somnifacient_
abolishments1993546abo_li_shments
abominations1646616abo_mination_s
aborigines1343516abor_i__gi_nes
abortionist1356186aborti_oni_st_
abortions1147796abort____ion_s
abortiveness1755336aborti___veness
abridgements1853046ab_r_idgements
abridgments1752936ab_r_i_dgments
amortization2347206amortization__
antifascists1762976a__ntifasci_sts
antiracists1357706a__ntiraci_sts
apostacies1445606apost__acie__s
apportionments2091946apporti_onments
arborizations2447426arbor_ization_s
artefacts1443156a__rtefac___ts
artifact1346146a__rtifac___t_
artificers1543506a__rtific_e_rs
artifices1446486a__rtific_e__s
bonifaces1643736_bo_nifac_e__s
coefficients2281906_co_efficients
fortifiers1644546_fortif__ie_rs
fortifies1548696_fortif__ie__s
morticians1445706_morti__cian_s
mortifiers1544406_mortif__ie_rs
mortifies1439396_mortif__ie__s
obstinacies1572276ob_stinacie__s
outpatients1351716__out_patients
proficients1853416__pr_oficients
rubefacients19171156__rubefacients
vorticists1546086_vorti__ci_sts

Search took 11 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.403443402.0
2DLD Change Limit1247903710.31312100.3
3Display Results37370.0331121.2
 (SQL Overall)1786913710.74916624.0
 
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.