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

77 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
protestations155581(None) 
protestation1456361protestation_
attestations1244463_attestations
contestations1547733contestations
detestations1347583_detestations
forestations1546323_forestations
molestations1475473_molestations
potentiations1555183p_otentiations
presentations1548133presentations
progestational1762753progestational
prostrations1449763pro__strations
protections15510703prote__ctions
protonations1449073prot_onations
restations10315843_r__estations
afforestations2062244afforestations
attestation1145184_attestation_
contestation1448664contestation_
deforestations1853964deforestations
detestation1248364_detestation_
erotizations21411004erot_izations
fomentations1746794_fomentations
forestation1447004_forestation_
gestations1139774___gestations
infestations1546624_infestations
molestation1365964_molestation_
orchestrations19113304orchestrations
orientations1246914or_ientations
ostentations1246124_ostentations
outstations1145344__outstations
peltations12311554p___eltations
photostating18135844photostati_ng
pigmentations1854094pigmentations
placentations17103634placentations
potations111615074p_o___tations
potentiation1455974p_otentiation_
predations13812154pr__e_dations
predestinations1865004predestinations
premeditations1955014premeditations
presentation1448994presentation_
preservations1895544preservations
probations14311084pro___bations
processions1548154proces__sions
proclamations1952694proclamations
procreations1647274pro_creations
procurations1647404pro_curations
profanations17175254pro_fanations
professions1646634profes__sions
progestins1348664proges__ti_ns
projections2258474proje__ctions
proletarians1455594prole_tarians
prolongations1673354prolongations
promulgations1892834promulgations
pronations12314034pro___nations
propagations1745554pro_pagations
propitiations1756204propitiations
propositions16108314propos_itions
prorations12314464pro___rations
prorogations1556724pro_rogations
prosecutions1645614prose_cutions
prostatisms1555864pro__statisms
prostatitis1355864pro__statitis
prostitutions1554254prostitutions
prostration13410794pro__stration_
protection14511474prote__ction_
protestant1247424protesta___nt
protestants1354554protesta__nts
protesting131910254protes__ti_ng
protestors12169314protes__t_ors
protistans1245204protista___ns
protonation13510434prot_onation_
protractions1646644prot_ractions
provocations1956874pro_vocations
reforestations1754464reforestations
restation9316914_r__estation_
rotations91613844_ro___tations
sustentations1354784sustentations
workstations1952054_workstations

Search took 7 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.360496363.9
2DLD Change Limit95024775.61016938.3
3Display Results77770.0461673.9
 (SQL Overall)178691776.01629702.6
 
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.