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

103 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
pretexted1913569(None) 
pretested12149111pretested
precented14310692precented
preheated1539812preheated
prelected1439132prelected
presented12311632presented
pretasted12147962pretasted
pretended1337192pretended
pretext1639662pretext__
pretexts1735602pretext_s
pretreated1347622pretreated
prevented1539002prevented
protected14158652protected
protested12159112protested
retested92212532_retested
breveted1435623breve_ted
brevetted1543863brevetted
detected12289733_detected
detested10279623_detested
fretted113411853fret__ted
greeted93111383gre_e_ted
patented1188893p_atented
perfected1736643perfected
permeated1439373permeated
perverted1546103perverted
petered103314973p_ete_red
petted94121523p_et__ted
praelected1544393praelected
preacted132710943pre_acted
preceded1438293prece_ded
precessed1437523precessed
precited133013813pre_cited
predated12513273pre_dated
predicted1538913predicted
preedited1337633preedited
preelected1545783preelected
preempted1644683preempted
preened103214993pre_e_ned
preerected1545573preerected
preexcited2243503pre_excited
preexisted2043783pre_existed
preferred1555003preferred
prefixed21357703prefix_ed
preheater1448913preheater
premixed20338013premix_ed
prepasted14137673prepasted
presentee11411863presentee
presenter11311643presenter
preserved15107563preserved
presettled1344083presettled
presifted1536873presifted
presorted1239453presorted
pretaped13339133pret_aped
pretaste10139523pretaste_
pretastes11119423pretastes
preteen939873prete__en
pretence122312123pretence_
pretences132312613pretences
pretend104011013prete__nd
pretender1246663pretender
pretense10199823pretense_
pretenses112210593pretenses
preterite11613203preterite_
preterites12411793preterites
pretest9517633pretest__
pretests10310013pretest_s
pretexting20206973pretexting
pretheater1545543pretheater
prettied1159253pret_tied
pretyped16306123pret_yped
preunited1246803preunited
preventer1438593preventer
priested1138393pr_iested
projected21165823projected
prosected14158633prosected
protecter13179103protecter
protended1336803protended
protester111510483protester
reested82916233_re_ested
refected142311663_refected
reheated122415003_reheated
rejected182710113_rejected
relented92614943_relented
remelted11310153_remelted
renested92212953_renested
repeated113117443_repeated
repented112614983_repented
rerented92516163_rerented
reseated93220263_reseated
resected112514743_resected
resented92716963_resented
retasted92412113_retasted
retaxed153512233_retax_ed
reteamed1138013_reteamed
retextured1842403_retextured
retinted94414363_retinted
retorted9312333_retorted
retreated10312623_retreated
retted74826313_ret__ted
reverted122714713_reverted
revested122612243_revested
revetted122210943_revetted
rewetted12228353_rewetted

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.423422437.4
2DLD Change Limit1486411036.93621430.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.40524131.1
 
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.