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

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

68 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
precipitation196622(None) 
precipitations2085391precipitations
precipitating2074032precipitating
precipitative2253602precipitative
precipitator1853582precipitat_or
crepitation1548393cre__pitation
decapitation1748683_decapitation
precipitate1755323precipitat__e
precipitated1954023precipitat_ed
precipitately2262453precipitately
precipitates1854633precipitat_es
precipitators1953273precipitators
precipitin1655863precipi__ti_n
premeditation1855703premeditation
recitation12315943_rec__itation
brecciation1744774brec_ci_ation
capitation14311364___capitation
crepitations1647474cre__pitations
debilitation1547784_debilitation
decapitations1847664_decapitations
decrepitation1884804_decrepitation
delimitation1597264_delimitation
elicitation1347534__elicitation
facilitation1746574_facilitation
felicitation1745104_felicitation
pacification2168054p_acification
palpitation1546244p__alpitation
pectination15410334p_ec_tination
perspiration1656834p_erspiration
preadaptation1852144preadaptation
precapitalist19123154precapitalist
precipitable2053404precipita_ble
precipitance2053134precipita_nce
precipitances2163094precipitances
precipitancies2262424precipitancies
precipitancy2362524precipita_ncy
precipitant1755014precipita__nt
precipitantly2262494precipitantly
precipitants1853334precipita_nts
precipitins1746174precipi__tins
predication16412434pre__dication
predomination1896534predomination
prefiguration1953454prefiguration
prelibation15128664pre__libation
premeditations1955014premeditations
premigration1755694premi_gration
prenomination17126754prenomination
preordination1656154preordination
preparation1549274pre__paration
presentation1448994pre_sentation
prettification21115714prettification
preunification2154304preunification
prevarication2055244prevarication
propitiation1656914pr__opitiation
recantation1349864_rec_antation
recapitulation1862494_recapitulation
reciprocation19183494_reciprocation
recitations13314204_rec__itations
recompilation1955154_recompilation
recomputation1974394_recomputation
recrimination1757404_recrimination
rectification2049514_rectification
recuperation1656724_recuperation
reification16412904_re_ification
reputation12411884_re__putation
respiration13511194_re_spiration
specification2245764specification
trepidation1445494tre__pidation

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 Filter178691950240.343520965.0
2DLD Change Limit95024685.17318369.2
3Display Results68680.0461478.3
 (SQL Overall)178691685.56232127.1
 
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.