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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
pinnate93613741pinnat_e
pinnated11338551pinnated
innate63917312_innat_e
pennate93314032pennat_e
pennated11299542pennated
pinnace113510312pinna_ce
pinnaces12268862pinnaces
pinnacle12416962pinnacle
pinnae84414642pinna__e
pinnately1443752pinnately
annates72415423_annates
binate8419773bi_nat_e
binnacle12325633binnacle
bipinnate1342763bipinnat_e
connate9315753connat_e
ingate73018243_ingat_e
ingates82716913_ingates
inmate82917363_inmat_e
inmates92715783_inmates
innage73011573_inna_ge
innages82911303_innages
innately1145613_innately
invitee103713543_invitee
jinnee13411573jinn__ee
kidnapee1552583kidnapee
lineate7815153lineat_e
lineated9711063lineated
manatee9317663_manatee
penates93321603p_enates
pennae84314033penna__e
penname11328553penna_me
pennames12287793pennames
phenate12412203phenat_e
phenates13611583phenates
phonate12411813phonat_e
phonated1447893phonated
phonates13410643phonates
picante11310523picant_e
picotee11311473pi_cotee
picrate112014143picrat_e
picrated132110113picrated
picrates122013213picrates
pileate93815923pileat_e
pileated112711133pileated
pinaster1037113pinaster
pinata83817223pi_nat_a
pinatas93711503pi_natas
pinite8321243pi_nit_e
pinites9319533pi_nites
pinna75320183pinna___
pinnacled14304503pinnacled
pinnacles13276043pinnacles
pinnal84814283pinna__l
pinnas85315523pinna__s
pinnation1138013pinnation
pinned94818383pinn__ed
pinner84521503pinn__er
pinnies93318443pinn_ies
pinniped1343853pinniped
pinnulae1044183pinnulae
pinnulate1145763pinnulat_e
pinnule936003pinn_ule
pinnules1036473pinnules
pintle83818263pi_n_tle
pinwale1257843pinwa_le
pinwales1367963pinwales
pirate82322883pi_rat_e
pirated102515613pi_rated
pirates93020333pi_rates
planate9314573planat_e
pronate9418873pronat_e
pronated11414053pronated
pronates10418373pronates
sinuate7412163sinuat_e
sinuated938413sinuated
sinuates8310963sinuates
spinate93114813spi_nat_e
spinnaker1542313spinnaker
tannate71813523tannat_e
tannates81911953tannates
wannabee1343993wannabee
winnable13156983winnable
zincate1838533zincat_e
zincates1937743zincates

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162846.95621012.4
3Display Results84840.0302800.0
 (SQL Overall)178691847.40624127.9
 
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.