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

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

94 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
presentational167321(None) 
presentation1448992presentation__
presentations1548132presentation_s
orientational1353803or_ientational
progestational1762753progestational
dissertational1562574dissertational
gestational1245114_ges__tational
nonsensational1463274nonsensational
permutational1752694p_ermutational
preoperational1853244preoperational
presentative1755344presentati__ve
preservation1776284preservation__
preservations1895544preservation_s
prevocational2054014pre_vocational
repetitional1453724_repe_titional
representation16154124representation__
representations17153894representation_s
reputational1474584_re_putational
sensational1146384___sensational
unsensational1353664_unsensational
vegetational1653374_vege_tational
assentation1146185_assentation__
assentations1245835_assentation_s
cementation1559705_cementation__
cementations1659015_cementation_s
compensational2073525compensational
condensational1753655condensational
conservational1955345conservational
dispensational1762505dispensational
documentational2061965documentational
expectational2452495_expectational
fermentation1756825fermentation__
fermentations1856275fermentation_s
frequentation2552635frequentation__
frequentations2652245frequentation_s
generational1354825_gene_rational
gravitational1762555gr_avitational
incantational1553565_incantational
irrotational1254025ir__rotational
levitational1553635_le_vitational
observational1853185_observational
orchestrational2071875orchestrational
orientation1147575or_ientation__
orientationally1872055or_ientationally
orientations1246915or_ientation_s
pentagonal1363565p___enta_gonal
perceptional1854905perce__ptional
perennation1348085p_erennation__
perennations1447255p_erennation_s
perorational1446395p_e_rorational
personation1349485person_ation__
personations1448395person_ation_s
perturbational1861205perturbational
pigmentation1754485pigmentation__
pigmentations1854095pigmentation_s
placentation1694155placentation__
placentations17103635placentation_s
postulational1553915p_ostulational
precentorial1654985precentori__al
precessional1655125prece__ssional
premeditation1855705premeditation__
premeditations1955015premeditation_s
prepositional1755195pre_positional
preselection16154885preselection__
preselections17144445preselection_s
presentability2164505presentability
presentient1348325presen__tien_t
presentimental1861925presentimental
presenting131013025presen__ti_n_g
preservationist2062805preservationist
presetting131010835prese_t_ti_n_g
preventative2054315preventati__ve
preventatives2152935preventati_ves
prevention1549175preven__tion__
preventions1648535preven__tion_s
probational1547085pr___obational
projectional2355425proje__ctional
pronunciational1971625pronunciational
protestation1456365protestation__
protestations1555815protestation_s
recantation1349865_recantation__
recantations1448875_recantation_s
recreational1455175_re_creational
reformational18113425_reformational
relational1047715_r__e_lational
reservation1489145_reservation__
reservations1588585_reservation_s
restation9316915_res__tation__
restationed1244375_res__tationed
restations10315845_res__tation_s
rotational1048095_r___otational
stational948515___s__tational
terminational1553485termin_ational
transnational1353915transn_ational

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 Filter178691950240.390458182.1
2DLD Change Limit95024947.20313192.3
3Display Results94940.0631492.1
 (SQL Overall)178691947.65623340.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.