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

57 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
premeditations195501(None) 
premeditation1855701premeditation_
premeditating1953652premeditati_ng
premeditators1862332premeditat_ors
remediations1548272_remedi_ations
meditations1449333___meditations
precipitations2085393precipitations
predications17411183pr__edications
premeditates1753753premeditat__es
premeditative2162913premeditati_ve
premeditator1752713premeditat_o_r
preordinations1765713preordinations
presentations1548133prese_ntations
rededications1746123_rededications
remediation1449213_remedi_ation_
accreditations19122624accreditations
bioremediations2061254bioremedi_ations
cementations1659014_ceme_ntations
crepitations1647474cr__epitations
fermentations1856274ferme_ntations
mediations13310984___medi_ations
medications1649934___medications
meditation13410744___meditation_
overmedications2363664overmedications
periodizations2655574periodizations
permeations1549884perme___ations
permutations1646504perm__utations
pigmentations1854094pigme_ntations
preadaptations1951754preadaptations
precipitation1966224precipitation_
predations13812154pr__ed__ations
predestinations1865004predestinations
predication16412434pr__edication_
predictions1649654pr__edi_ctions
predominations19105544predominations
prelibations16127624pr__elibations
premeditate1654404premeditat___e
premeditated1853534premeditat__ed
premeditatedly2371124premeditatedly
premonitions1646854premoni__tions
premunitions1644984premuni__tions
prenominations18105764prenominations
preordination1656154preordination_
presentation1448994prese_ntation_
preservations1895544prese_rvations
preterminations1954304preterminations
prevarications2154744prevarications
protestations1555814prote_stations
recitations13314204_r__ecitations
rededication1646504_rededication_
reeditions1147654_re_edi__tions
reeducations1545474_re_educations
remediating1547134_remedi_ati_ng
remotivations1846694_remotivations
repudiations1597034_repudi_ations
reradiations1349494_reradi_ations
revegetations17114714_revegetations

Search took 4 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 Filter178691658740.326548131.9
2DLD Change Limit65874573.17320760.8
3Display Results57570.0301900.0
 (SQL Overall)178691573.52950635.0
 
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.