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

67 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
foreordinations19102061foreordinations_
foreordination1892282foreordination__
preordinations1765713_preordinations_
coordinations1684994co__ordinations_
preordination1656154_preordination__
coordination1595585co__ordination__
fluorinations16103975f_luor_inations_
foreordains1552165foreord__a_i_ns_
incoordinations18162655incoordinations_
ordinations1247995____ordinations_
peregrinations17114685peregr_inations_
subordinations1754005_subordinations_
arborizations2447426_arbor_izations_
bioremediations2061256bioremedi_ations_
brominations1646746_br_o_minations_
chlorinations1855536_chlor_inations_
colorizations241410356co_lor_izations_
coordinating1653916co__ordinati_n_g
coordinators1553806co__ordinat_ors_
coronations13410706cor_o___nations_
corporations16129486corpor___ations_
creolizations2457886_creo_lizations_
determinations1766896dete_rminations_
exterminations2365126exte_rminations_
factorizations2855766factor_izations_
fiberizations27136366fibe_r_izations_
floriations1476916f__lor_i_ations_
fluoridations1783226f_luor_idations_
fluorination1594716f_luor_ination__
foreordain1452156foreord__a_i_n__
foreordained1761386foreord__a_i_ned
foreordaining1861076foreordain__i_n_g
forestations1546326fore___stations_
formalizations28146986for_malizations_
fornications1755396f___ornications_
fortifications2286216for_tifications_
germinations15137946__ge_rminations_
incardinations1754416_incardinations_
incoordination17172936incoordination__
iodinations1268846___io_dinations_
modernisations1752726mode_rnisations_
modernizations2654936mode_rnizations_
motorizations2449126mo_tor_izations_
ordination1149416____ordination__
originations13106186_or__iginations_
peregrination16125206peregr_ination__
periodizations2655576perio_dizations_
predications17411186_pre__dications_
predominations19105546_predominations_
premeditations1955016_premeditations_
prenominations18105766_prenominations_
preterminations1954306_preterminations_
recombinations2095586__recombinations_
recordations1548646__record__ations_
recriminations1856726__recriminations_
rededications1746126__rededications_
remediations1548276__remedi_ations_
renominations15108306__renominations_
reorientations1465216__reorientations_
reoxidations2046046__reo_xidations_
repudiations1597036__repudi_ations_
reradiations1349496__reradi_ations_
subordination1654176_subordination__
terminations14149756__te_rminations_
terrorizations2356176terror_izations_
theorizations2576156_theor_izations_
trephinations1853556_tre_phinations_

Search took 6 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 Filter178691658740.0931921408.6
2DLD Change Limit65874675.34312329.0
3Display Results67670.0631063.5
 (SQL Overall)178691675.49932495.2
 
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.