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

96 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
recreation1241361(None) 
recreations13412251recreations
creation102816512__creation
procreation1547952procreation
reception13410322rec_eption
recitation12315942recitation
recordation1449262recordation
recreating131214582recreating
recreational1455172recreational
recreative1549022recreative
secretion11118302secre_tion
accretion1345933accre_tion
aeration8319933ae_r_ation
brecciation1744773brecciation
creatin93618133__creati_n
creations112614543__creations
cremation13511643__cremation
crenation11412923__crenation
deaeration11313013deaeration
deception1448323dec_eption
decimation15411623decimation
decoration13314423decoration
decryption1843733decryption
deprecation1648963deprecation
depredation1546923depredation
erection102115513_e_rection
excretion1846713excre_tion
execration1949833execr_ation
federation1449573federation
generation11312423generation
incretion1149053incre_tion
laceration1249573laceration
laureation1046153laureation
maceration1449613maceration
miscreation1547723miscreation
nervation12610243ne_rvation
nucleation1245963nucleation
peculation14311993peculation
perception1688613perception
permeation14410563permeation
procreations1647273procreations
recantation1349863recantation
recaution1148093rec_aution
recension1148863rec_ension
receptions1449743rec_eptions
recession1149103rec_ession
recitations13314203recitations
reclamation1546353reclamation
recordations1548643recordations
recrating121318793recr_ating
recreate10313603recreat__e
recreated12412533recreat_ed
recreates11313363recreat_es
recreationist1555743recreationist
recuperation1656723recuperation
redirection1446053redirection
reelection12198633reelection
refection141512283re_fection
reflation12412333re_flation
reflection15168993reflection
reformation1648413reformation
refraction15137903refraction
refutation1349913refutation
regression1146953regression
regulation11312053regulation
reiteration11412163reiteration
rejection181710253re_jection
relation82619773re__lation
relaxation1746453relaxation
relegation11610023relegation
relocation12312113relocation
renovation1358783renovation
reoperation13410903reoperation
reparation12612723reparation
repletion1147693reple_tion
repression1249043repression
reprobation1548503reprobation
reputation12411883reputation
resection111613273re_section
reservation1489143reservation
restation9316913re_station
retardation12106863retardation
retention91611483re_tention
retraction121310533retraction
retreating111414773retreating
retroaction1347363retroaction
revelation13410923revelation
revocation15410813revocation
secretin10108343secre_ti_n
secretions12117853secre_tions
segregation1346383segregation
seriation9318063se_riation
serration9414063se_rration
ulceration1247263ulceration
veneration13412343veneration
vernation12311083ve_rnation

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 Filter1786911406030.440406115.9
2DLD Change Limit140603966.53021531.9
3Display Results96960.0631523.8
 (SQL Overall)178691967.03325407.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.