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

161 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
respected143849(None) 
resected112514741res_ected
respecter1347441respecter
expected2036742_expected
inspected1445402inspected
prospected1744872prospected
reejected1955092reejected
reelected1238312reelected
reerected1238612reerected
refected142311662re_fected
reflected1547982reflected
reinspected1642982reinspected
rejected182710112re_jected
repeated113117442re_peated
repented112614982re_pented
reseated93220262res_eated
reselected1345632reselected
resented92716962res_ented
resmelted1236032resmelted
respaced1338502respac_ed
respect11412032respect__
respecters1445862respecters
respects1247702respect_s
respelled1257032respelled
respited11410812resp_ited
respotted1235952respotted
suspected1444382suspected
beseeched1743193beseeched
bisected1336203bis_ected
defected15289973de_fected
deflected1635983deflected
dejected19307593de_jected
depicted1437743de_picted
deselected1444083deselected
deserted101012203des_erted
despited1248323desp_ited
detected12289733de_tected
disjected2086353disjected
disrespected1852003disrespected
dissected13108663dissected
effected1744993_effected
ejected17297653_e_jected
elected102812613_e_lected
erected103213993_e_rected
expecter1936513_expecter
experted1838053_experted
exsected1835673_exsected
henpecked2141893henpecked
neglected1354693neglected
perfected1736633perfected
preelected1545773preelected
preerected1545573preerected
prelected1439123pre_lected
preselected1643963preselected
presented12311633pres_ented
prosected14158633pros_ected
reacted103015713re__acted
reasserted1145413reasserted
rechecked2143973rechecked
recreated12412533recreated
redacted12410243re_dacted
redefected1743853redefected
redirected1444773redirected
rednecked1743163rednecked
reenacted1236853reenacted
reested82916233re__ested
reexecuted2062693reexecuted
refracted1557393refracted
regreeted1136173regreeted
regretted1137233regretted
reheated122415003re_heated
reinfected1645253reinfected
reinjected2044443reinjected
rejectee17289623re_jectee
rejecter17258943re_jecter
relented92614943re_lented
relucted1138653re_lucted
remelted11310153re_melted
renested92212953re_nested
reobjected2242253reobjected
reopened1138503reope_ned
reoperated1348153reoperated
repacked17188743re_packed
repasted112611533re_pasted
repealed113211873re_pealed
repeater102615443re_peater
repegged1334893re_pegged
repelled113111573re_pelled
repenter102813863re_penter
reperked15177793re_perked
repetend1136223re_pe_tend
replated112817513re_plated
reported11312703re_ported
repotted1139283re_potted
reputed104613483re_p_uted
requested1935893requested
rerented92516163re_rented
rerepeated1346193rerepeated
resaluted1046473resaluted
rescued10410043res__cued
resealed92713963res_ealed
resect84424703res_ect__
resects94115593res_ect_s
resecured1245533res_ecured
reseed74823293res_e__ed
reseeded1038093res_eeded
reseized1839213res_eized
reserved121010583res_erved
resetter81511833res_etter
resettled1035303res_ettled
resewed113011823res_e_wed
resifted12310153res_ifted
resighted1436523resighted
resinated10413283resinated
resisted9312693res_isted
resited85122423res__ited
resketched2042313resketched
reslated93517523res_lated
resonated10510613resonated
resorted9313493res_orted
respace11310913respac_e_
respaces12311043respac_es
respaded1238133resp_aded
respecified1953373respecified
respecify1943133respecify
respectful1752933respectful
respecting1549883respecting
respective1747623respective
respelt9312143respelt__
respired1148993resp_ired
respite9513033resp_ite_
respites10513243resp_ites
respliced1445533respliced
responded1336513responded
respooled1245593respooled
resprayed1544353resprayed
resprouted1344223resprouted
restacked1636483restacked
restarted10410053restarted
restated93120183res_tated
rested74430783res___ted
restocked1655173restocked
restricted1348303restricted
resubjected2351493resubjected
resulted939713res_ulted
resurrected1452673resurrected
retested92212533re_tested
retracted12410953retracted
retreated10312623retreated
retrospected1752663retrospected
reverted122714713re_verted
revested122612243re_vested
revetted122210943re_vetted
rewetted12228353re_wetted
selected1159783se_lected
specced14266703__specced
specked16329013__specked
specter113111733__specter
tempested1444033tempested
trisected1244913tris_ected
unexpected2243113unexpected

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 Limit1486411617.59319576.1
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.81222873.9
 
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.