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

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

103 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
projectiles224380(None) 
projectile2144551projectile_
projections2258472projections
projective2446812projective_
projectable2452903projectable_
projected21165823project__ed
projecting22177243projecti_ng
projection2158763projecti_on
projectively2953983projectively
projectors21187173project_ors
projects1936413project___s
properties141411883properti_es
protections15510703protections
protective1748423protective_
adjectives2343734_adjectives
correctives1845574correctives
ejectives2145444__ejectives
erectile1039514er__ectile_
fromenties1546674fromenti_es
objectives2444534_objectives
pectines121914684p___ectines
pectizes21229794p___ectizes
percentiles1546204percentiles
perfectives2145474perfectives
perspectives2153514perspectives
poetises10313954p_o_e_tises
poetizes19310254p_o_e_tizes
poverties1439514p_overti_es
practices1557994pr__actices
practises1349624pr__actises
praecipes1544854pr_aec_ipes
prechills1645124pr__echills
precipes143212214pr__ec_ipes
precises123218334pr__ec_ises
predestines1446994predestines
prefectures1844304prefectures
prefiles133113444pr__e_files
prelections151210474prelections
prentices131111904pr__entices
presettles1245024prese_ttles
prestiges12310594pr__estiges
pretties10615134pr__etti_es
preventives1945724preventives
proactions1449344pro_actions
proactive1648364pro_active_
probities13312654pro_biti_es
procaines13311524pro__caines
proclises1339544pro__clises
proctitides1664714proctitides
proctitis1348364pro__ctitis
proctitises15106324proctitises
productions1647534productions
productive1845514productive_
proettes10312764pro_e_t_tes
profiles133211234pro___files
progenies12314124proge_ni_es
progestins1348664progesti_ns
project1838454project____
projectional2355424projectional
projectionist2485254projectionist
projector20186684project__or
projets1639164proje_t___s
prolactins1447154prolacti_ns
propertied15137254properti_ed
propertyless195984propertyless
prophecies1996504prophec_i_es
proscribes16125354pro_scribes
prosected14158634prosect__ed
prosecting15189814prosecti_ng
prosectors14199124prosect_ors
prosects1239474prosect___s
prosecutes1445664prosec_utes
prosecutions1645614prosecutions
proselytises1752814proselytises
proselytizes2652434proselytizes
prospective2055404prospective_
prospectuses1852484prospectuses
prosties101421194pro__sti_es
prostyles14157114pro__styles
protectants1554364protectants
protected14158654protect__ed
protecter13179104protect__er
protecters14168254protect_ers
protecting151910214protecti_ng
protection14511474protecti_on
protectively2254724protectively
protectories1656824protectories
protectors142010144protect_ors
protectress1553134protectress
protects1239744protect___s
proteides12238784prote__ides
protosteles1354564protosteles
protractile1554104protractile_
protyles13249834pro___tyles
proustites1246454pro_ustites
provocatives2253374provocatives
rejectees18235424_reject_ees
rejections191510104_rejections
rejective2148254_rejective_
reptiles103913064_r__eptiles
retiles74426994_r__e_tiles
subjectives2554764subjectives
trajections2044514trajections

Search took 9 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.403443402.0
2DLD Change Limit1488191038.25018038.7
3Display Results1031030.0631634.9
 (SQL Overall)1786911038.71620501.5
 
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.