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

148 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
pretested1214911(None) 
pretasted12147961pretasted
pretexted19135691pretexted
protested12159111protested
retested92212531_retested
detested10279622_detested
precented14310692precented
precessed1437522precessed
preheated1539812preheated
prelected1439132prelected
prepasted14137672prepasted
presented12311632presented
pretaste10139522pretaste_
pretastes11119422pretastes
pretended1337192pretended
pretest9517632pretest__
pretests10310012pretest_s
pretreated1347622pretreated
prevented1539002prevented
priested1138392pr_iested
protected14158652protected
protester111510482protester
reested82916232_re_ested
renested92212952_renested
retasted92412112_retasted
revested122612242_revested
arrested939153ar_rested
attested936293_attested
breasted1138823bre_asted
breveted1435623breve_ted
brevetted1543863brevetted
contested12310693contested
creeshed1435693cre_eshed
crested103416533cr__ested
detected12289733_detected
detester9239683_detester
devested13239133_devested
egested938123__egested
foretasted1484753foretasted
fretted113411853fret__ted
greeted93111383gre_e_ted
obtested1135453_obtested
patented1188893p_atented
perfected1736643perfected
permeated1439373permeated
persisted1247143persisted
pertest9317043pertest__
perverted1546103perverted
petered103314973p_ete_red
petted94121523p_et__ted
poetaster1145673poetaster
poetesses1137233poetesses
poetised1138523poetis_ed
praelected1544393praelected
preacted132710943pre_acted
preblessed1543473preblessed
preceded1438293prece_ded
precesses13310463precesses
precised133213413precis_ed
precited133013813pre_cited
predated12513273pre_dated
predestined1545183predestined
predicted1538913predicted
predigested1653073predigested
preedited1337633preedited
preelected1545783preelected
preempted1644683preempted
preened103214993pre_e_ned
preerected1545573preerected
preexisted2043783preexisted
preferred1555003preferred
preheater1448913preheater
premised133013193premis_ed
prepaste12139083prepaste_
prepastes13128823prepastes
presentee11411863presentee
presenter11311643presenter
preserved15107563preserved
presettled1344083presettled
presifted1536873presifted
presorted1239453presorted
pressed103317313pr__essed
prester93519623pr__ester
prestressed1444703prestressed
pretaped13339133pret_aped
preteen939873prete__en
pretence122312123pretence_
pretences132312613pretences
pretend104011013prete__nd
pretender1246663pretender
pretense10199823pretense_
pretenses112210593pretenses
preterite11613203preterite_
preterites12411793preterites
pretesting131810683pretesting
pretext1639663pretext__
pretexts1735603pretext_s
pretheater1545543pretheater
prettied1159253pret_tied
pretyped16306123pret_yped
preunited1246803preunited
preventer1438593preventer
prevised143611073previs_ed
previsited1645183previsited
prewashed1843923prewashed
processed1446803processed
professed1545243professed
projected21165823projected
prosected14158633prosected
protecter13179103protecter
protended1336803protended
protest9317533protest__
protesters12169383protesters
protestor11178493protestor
protests10310493protest_s
recessed1139713_recessed
refected142311663_refected
reheated122415003_reheated
rejected182710113_rejected
relented92614943_relented
relisted9312623_relisted
remelted11310153_remelted
repasted112611533_repasted
repeated113117443_repeated
repented112614983_repented
requested1935893_requested
rerented92516163_rerented
reseated93220263_reseated
resected112514743_resected
resented92716963_resented
resisted9312693_resisted
rested74430783_r__ested
retaste72313133_retaste_
retastes82212903_retastes
reteamed1138013_reteamed
retest64028453_retest__
retests73813853_retest_s
retinted94414363_retinted
retorted9312333_retorted
retreated10312623_retreated
retted74826313_ret__ted
retwisted1344893_retwisted
reverted122714713_reverted
revetted122210943_revetted
rewetted12228353_rewetted
tested74421523___tested
untested92612413_untested
wrested113410933wr__ested

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 Limit1486411486.59322545.3
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.07625253.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.