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

157 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
presorted123945(None) 
resorted9313491_resorted
preformed17176202preformed
prescored14409402prescor_ed
presented12311632presented
preserved15107562preserved
presifted1536872presifted
presoaked1635652presoaked
presolved1545272presolved
presort95219542presort__
presorts105311682presort_s
prestored125111672prestor_ed
preworked1954652preworked
reported11312702_reported
resorbed1138532_resorbed
resorter8312182_resorter
retorted9312332_retorted
assorted956603_assorted
besotted1135843_besotted
consorted1239773consorted
creosoted1244043creosoted
crested103416533cres__ted
dehorted1357303_dehorted
deported1249703_deported
deserted101012203_deserted
desorbed1236443_desorbed
escorted1136703__escorted
missorted1247033missorted
perforated1656893perforated
performed17155303performed
perorated12412463p_erorated
persisted1247143persisted
personated13258293personated
perverted1546103perverted
ported94223243p___orted
preabsorbed1851993preabsorbed
preacted132710943pre_acted
preadopted1644353preadopted
prearmed1397993pre_armed
preboarded1663893preboarded
preboiled1455783preboiled
prebooked1863913prebooked
precented14310693precented
precited133013813pre_cited
precoded1438863preco_ded
precooked1844993precooked
precooled1446363precooled
precured1339993precur_ed
predated12513273pre_dated
predicted1538913predicted
predried12309573pre_dried
preedited1337633preedited
preempted1644683preempted
preferred1555003preferred
prefired144310753prefir_ed
preheated1539813preheated
preinserted1443773preinserted
prelected1439133prelected
preloaded1335923preloaded
prelocated1597183prelocated
premolded1544683premolded
premorse1237553premorse_
preorder1136463pre_order
preowned1435213pre_owned
prepared132210873prepar_ed
prepasted14137673prepasted
presaged1238803pres_aged
presbyter1643733presbyter
prescore124812373prescor_e_
prescores133912173prescor_es
prescreen1345103prescreen
prescribed17105373prescribed
presentee11411863presentee
presenter11311643presenter
preserve13108803preserve_
preserver14127013preserver
preserves14109073preserves
presettled1344083presettled
preshaped1745523preshaped
preshowed1875183preshowed
presided12410553pres_ided
presliced1435983presliced
presold1059603preso__ld
presolve1347073presolve_
presolves1456533presolves
presorting1339983presorting
pressed103317313pres__sed
pressured1237333pressured
prester93519623pres__ter
prestore104217353prestor_e_
prestores114716083prestor_es
presumed1337973pres_umed
presurvey1744603presurvey
pretasted12147963pretasted
pretested12149113pretested
pretexted19135693pretexted
preunited1246803preunited
prevented1539003prevented
prewarmed17104563prewarmed
prewarned1594773prewarned
prewired14358473prewir_ed
priested1138393pries__ted
prisoned1138813priso_ned
promoted13310543promo_ted
prorated11513713pr__orated
prosected14158633prosected
prostrated1349423prostrated
purported1443463purported
reassorted1144363_reassorted
rebooted11248463_rebooted
rebored105015883_rebor_ed
recoated113416783_recoated
recorded122511063_recorded
recorked15239853_recorked
reforged13268703_reforged
reformed14249603_reformed
regorged11227333_regorged
reporter10411423_reporter
repotted1139283_repotted
rerouted9311143_rerouted
rescored114513103_rescor_ed
reseated93220263_reseated
resected112514743_resected
resented92716963_resented
reserved121010583_reserved
resifted12310153_resifted
resisted9312693_resisted
resited85122423_res_ited
reslated93517523_reslated
resoaked1337943_resoaked
resodded1136353_resodded
resoften1145443_resoften
resoled84119283_reso_led
resolved12349343_resolved
resonated10510613_resonated
resort65728623_resort__
resorters939693_resorters
resorts74817193_resort_s
resowed113712253_reso_wed
respited11410813_respited
respotted1235953_respotted
restarted10410053_restarted
restated93120183_restated
rested74430783_res__ted
restored96417193_restor_ed
resulted939713_resulted
resurged1038623_resurged
retorter8410733_retorter
reverted122714713_reverted
revolted12319863_revolted
revoted114314153_revo_ted
reworded13228103_reworded
reworked16247773_reworked
sorted74523713___sorted
unreported1344073unreported
unsorted9312513_unsorted
wrested113410933wres__ted

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.410435831.7
2DLD Change Limit1486411576.81021826.9
3Display Results1571570.0801962.5
 (SQL Overall)1786911577.30024478.2
 
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.