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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
preventer143859(None) 
presenter11311641presenter
prevented1539001prevented
preventers1547391preventers
perverter1445562perverter
precented14310692precented
precentor1348732precentor
preener93114832pre_en_er
preheater1448912preheater
presented12311632presented
presentee11411862presentee
presenters1239862presenters
pretender1246662pretender
prevent124016552prevent__
prevents133012292prevent_s
provender1544892provender
recenter102715442_recenter
reenter73217792_re_enter
repenter102813862_repenter
revenger1237302_revenger
revenuer1136892_revenuer
reverter114812872_reverter
breveted1435623breve_ted
brevetted1543863brevetted
cementer1239193_cementer
decenter112412163_decenter
evener91010623__even_er
fermenter1497543fermenter
frequenter2243413frequenter
greener83111713gre_en_er
greenier938713gre_enier
greeter82812673gre_e_ter
inventer112410843_inventer
levanter1145303_levanter
orienter838313or_ienter
patienter1145553patienter
perfecter1646043perfecter
perverted1546093perverted
perverters1544963perverters
prealter1048863pre_alter
precancer1547093precancer
precensor1345253precensor
precent113520263precent__
precentors1488343precentors
precents123015043precent_s
preceptor1547323preceptor
predinner1245133predinner
preened103214983pre_en_ed
preeners102712813pre_en_ers
preferrer1443893preferrer
preheated1539813preheated
preheaters1557193preheaters
prelected1439123prelected
prelector1348093prelector
premerger1444903premerger
prepense12238943prepense_
presbyter1643733presbyter
presence122213513presence_
presences132113793presences
present94022733present__
presentees1247923presentees
presently1449053presently
presents103315643present_s
preserver14127013preserver
prester93519623pr__ester
pretence122312123pretence_
pretences132312613pretences
pretended1337193pretended
pretenders1345243pretenders
pretense10199823pretense_
pretenses112210593pretenses
pretested12149113pretested
pretexted19135683pretexted
pretheater1545543pretheater
prevailer1445153prevailer
prevenient1547813prevenient
preventing161210263preventing
prevention1549173prevention
preventive1847543preventive
preventives1945723preventives
previewer1743023previewer
printer93917303pr__inter
privater13158533priv_ater
protecter13179103protecter
protester111510483protester
provenders1644273provenders
ravener104110733_raven_er
recanter101913153_recanter
reenters82915303_re_enters
reheater113413033_reheater
reinter73116843_re_inter
rejecter17258943_rejecter
relented92614943_relented
reletter81311023_reletter
renter64527413_r__enter
repeater102615443_repeater
repented112614983_repented
repenters112511553_repenters
representer1353613representer
rerented92516163_rerented
resented92716963_resented
resetter81511833_resetter
revealer113110073_revealer
reveler104116343_reve_ler
reveller112912183_reveller
revenge1138573_revenge_
revenged1337553_revenged
revengers1336413_revengers
revenges1238983_revenges
revenue1039533_revenue_
revenued1237223_revenued
revenuers1235983_revenuers
revenues1138663_revenues
reverer103815833_reve_rer
reverser113010483_reverser
reverted122714713_reverted
reverters122710433_reverters
revested122612243_revested
revetted122210943_revetted
revolter11279363_revolter
riveter10208753_rive_ter
unevener1144123uneven_er
venter94218723___venter

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411237.32620289.5
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.52823736.8
 
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.