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

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

215 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
approximative296192(None) 
approximate24132882approximat__e
approximating2761802approximating
approximation2652232approximation
appreciative2153963appreci_ative
appropriative1963023appropriative
approximated26142403approximat_ed
approximately2981573approximately
approximates25112653approximat_es
approximations2761963approximations
applicative2074714app__licative
appointive1793804app_o_i_ntive
appositive1744844app_osi__tive
proximate2045774__proximat__e
achromatize2755435achro__matize
affricative2253035affr__icative
appellative1853075app__ellative
appetitive1753755app_eti__tive
appositives1854255app_osi__tives
appraisive1753205appr_ai__sive
appreciate1655245appreci_at__e
appreciating1954105appreci_ating
appreciation1855305appreci_ation
appreciatively2672315appreci_atively
approbate1546565appro__bat__e
approbating1844585appro__bating
approbation1755025appro__bation
appropriate1464285appropriat__e
appropriating1783495appropriating
appropriation1653825appropriation
aromatize20410305a__ro__matize
associative1653855a_ssoci_ative
authoritative1961985authoritative
depreciative2084095depreci_ative
exploitative2452595explo_itative
inappreciative2361705inappreci_ative
oxidative2044315____oxidative
performative22103875_performative
predicative1947375__predicative
primitive1646395__pr__imitive
privative17188295__pr__ivative
probative1649175__pro__bative
procreative1846315__procreative
prohibitive2152825__prohibitive
promotive1648035__pro__motive
propagative1954505__propagative
provocative2154645__provocative
proximately2552225__proximately
proximities2255885__proximities
reprobative1855645repro__bative
unappreciative2381605unappreci_ative
acclimatise1753616a__cclimatise
acclimatize2653946a__cclimatize
achromatic1949026achro__mati_c
achromatism2055336achro__matism
achromatized2953756achro__matized
achromatizes2854696achro__matizes
adjudicative2661966a_djudicative
advocative1943966a_dvo__cative
affirmative2253096a__ffirmative
affricatives2351976affr__icatives
agglomerative2061916agglomerative
agglutinative1862066agglutinative
aggregative1753376aggr__egative
agitative1346876a____gitative
amative12311736a______mative
annotative1345036a_nno__tative
aphrodite1545486aphrodi__t__e
aposematic1654256a_p_osemati_c
apostatise1255266a_p_o_statise
apostatize2164576a_p_o_statize
appellatives1952046app__ellatives
apperceptive2052956app_erceptive
application1747476app__lication
applicatively2562546app__licatively
appointee1345006app_o_i_nt_ee
appointing1545326app_o_i_nting
apposite12410016app_osi__t__e
apposition1446596app_osi__tion
appositively2252766app_osi__tively
appraise1247706appr____a_ise
appreciable1953856appreci_a_ble
appreciated1854226appreci_at_ed
appreciates1754756appreci_at_es
appreciations1964776appreci_ations
appreciator1754146appreci_at_or
appreciators1853546appreci_ators
appreciatory2153226appreci_atory
apprehensive2262576appr_ehensive
apprentice1654326appr___entice
approachable2362256approacha_ble
approbated1744766appro__bat_ed
approbates1645866appro__bat_es
approbations1854246appro__bations
approbatory2062906appro__batory
appropriable1762716appropria_ble
appropriated1663496appropriat_ed
appropriately1962656appropriately
appropriates1564076appropriat_es
appropriations1763176appropriations
appropriator1563606appropriat_or
appropriators1663386appropriators
approvable1963936appro__va_ble
approve14116606appro______ve
arbitrative1654266a__rbitrative
aromatase1145286a__ro__matase
aromatic12315646a__ro__mati_c
aromatics13410906a__ro__matics
aromatized2257256a__ro__matized
aromatizes2159196a__ro__matizes
ascriptive1753836ascr__i_ptive
asphyxiate2561826asphyxi_at__e
asphyxiating2861186asphyxi_ating
asphyxiation2761386asphyxi_ation
assimilative1763176a_ssimilative
assortative1473956a_sso_rtative
attributive1652696attr__ibutive
attritive1246086attr__i__tive
automatize2196566a_uto__matize
automotive1554206a_uto__motive
autoxidation2053786a_utoxidation
axiomatize2874256a____xiomatize
carminative1844896_car_minative
cogitative1645936___cogitative
coordinative1853086coor_dinative
corporative1847156corpo__rative
corroborative2062106corroborative
deformative2044976_defo_rmative
denominative1854406_denominative
derivative1746686_der__ivative
derogative1546986_dero__gative
dissociative18133736dissoci_ative
dominative1677396___dominative
duplicative1954176dup__licative
epoxidation2144066_ep_oxidation
estimative1546486___estimative
excogitative2562116_excogitative
exfoliative2452486_exfoli_ative
explicative2554456exp__licative
exploitive2253466explo_i__tive
explorative2354246explo__rative
expositive2254516exp_osi__tive
formative1747966___fo_rmative
fricative1746746__fr__icative
germinative1755046_ger_minative
gravitative1852976__gravitative
implicative2054666imp__licative
improvisation2052996improvisation
improvisatore20152376improvisatore
informative1965156_info_rmative
irradiative1552896_irradi_ative
irritative1345206__ir_ritative
lubricative1853456lubr__icative
meprobamate1961886meprobamat__e
motivative1844286___motivative
nominative1597686___nominative
nonnormative1754866nonno_rmative
normative1448896___no_rmative
operative141110556oper____ative
originative1553936__originative
palliative1544776__palli_ative
participative2263006participative
partitive1447376_par_ti__tive
patronization2456766patronization
pejorative2245696_pejo__rative
performatives2392686_performatives
permeative1748526_per__meative
peroxidase2053196_peroxida__se
personative1647076_per_sonative
photooxidative3072386photooxidative
portative1449376__p_o_rtative
positive1349996__p_osi__tive
precative16312576__pr__ecative
predictive1847426__predi_ctive
preemptive1944146__pr_eemptive
preoperative1955756_preoperative
preparative1846356__preparative
prerogative1755356__prerogative
presumptive2063066__presumptive
primate111516286__pr__imat__e
primatial1348106__pr__imatial
primitives1745626__pr__imitives
privatise14167776__pr__ivatise
privatives18186476__pr__ivatives
privatize23167046__pr__ivatize
proactive1648366__pro__active
productive1845516__pro_ductive
projective2446816__pro_jective
proliferative2162356__proliferative
prospective2055406__prospective
protective1748426__pro_tective
protractive1855636__protractive
provocatives2253376__provocatives
proximal1945186__proxima___l
proximally2443786__proxima_lly
proximateness2462456__proximateness
proximity2344676__proxim__ity
purgative1545286_pur___gative
radiative1348176___radi_ative
ratiocinative1862216ratiocinative
recitative1548186___recitative
recriminative2053456recriminative
reformative1945676_refo_rmative
replicative1846086rep__licative
reprivatize2554416repr__ivatize
reproductive20124336repro_ductive
retrodictive1853876retrodi_ctive
rotative11310346___ro__tative
ruminative1546436___ruminative
seronegative1652706_seronegative
sporulative1653746_sp_orulative
subordinative1962426subordinative
terminative1656136_ter_minative
unproductive2073116unpro_ductive
urinative1247656__ur__inative

Search took 20 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.470380193.6
2DLD Change Limit14881921519.2807718.8
3Display Results2152150.1431503.5
 (SQL Overall)17869121519.8938982.6
 
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.