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

321 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
repotted113928(None) 
replotted1235821replotted
reported11312701reported
respotted1235951respotted
bedotted1234982bedotted
besotted1135842besotted
deported1249702deported
potted94624012__potted
rebooted11248462rebooted
rebottled1243432rebottled
rebutted11126782rebutted
recoated113416782recoated
refitted12309412refitted
reknotted1443522reknotted
remitted113312072remitted
repasted112611532repasted
repeated113117442repeated
repented112614982repented
replated112817522replated
repolled11359622repolled
reporter10411422reporter
reposed103616272repo_sed
reposited1239132reposited
repoured1139562repoured
reputed104613482rep_uted
rerouted9311142rerouted
resorted9313492resorted
retorted9312332retorted
retted74826312re__tted
revetted122210942revetted
revolted12319862revolted
revoted114314152revo_ted
rewetted12228352rewetted
riposted11216932riposted
rotted74524432r__otted
spotted103713142_spotted
unpotted11108392unpotted
allotted986873allotted
befitted14305723befitted
begotten1143243begotten
beknotted1642353beknotted
betted94721163be__tted
blotted103911833_blotted
brevetted1543863brevetted
clotted104011823_clotted
coplotted1444793coplotted
crepitated1584743crepitated
decocted1437683decocted
defatted1335673defatted
dehorted1357303dehorted
demitted12288773demitted
demoted114313543demo_ted
denoted93512763deno_ted
departed1238823departed
depicted1437743depicted
depleted12258723depleted
deponed113712873depo_ned
deportee11510353deportee
deporter1169393deporter
deposed113412023depo_sed
deposited1346773deposited
deputed114610173dep_uted
deratted1048403deratted
devoted124111093devo_ted
dotted84717523__dotted
emitted103010853_emitted
emoted94614923_emo_ted
epoxied1734813_epoxied
epoxyed2032293_epoxyed
exported1837133exported
fetted104817893fe__tted
fretted113411853fre__tted
garotted1066193garotted
gavotted1363343gavotted
hotted104319943__hotted
imported13308693imported
imposted13257403imposted
inputted1134663inputted
jetted143915083je__tted
jotted143615173__jotted
knotted12357233_knotted
letted74118543le__tted
lotted74222403__lotted
netted74118713ne__tted
patted94724683__patted
petted94121523__petted
pipetted1335263pipetted
pitted94319593__pitted
plotted104612373_plotted
ported94223243__ported
posted93722493__posted
potter83926983__potter
pouted94021393__pouted
prepasted14137673prepasted
presorted1239453presorted
putted94220253__putted
ragouted1034423ragouted
ratted74923343r__atted
reacted103015713re_acted
readopted1344913readopted
reallotted1142993reallotted
rebaited11410543rebaited
rebated103619703re_bated
rebodied1237243rebodied
reboiled11349393reboiled
rebooked15226503rebooked
rebored105015883rebo_red
rebottle1044343rebottle
rebottles1143873rebottles
rebutter10106273rebutter
recanted112513513recanted
recited104319103re_cited
reclothed1544593reclothed
recoaled113111783recoaled
recocked17248473recocked
recoded113115033reco_ded
recoiled113613213recoiled
recoined113614423recoined
recombed1536713recombed
reconned113610653reconned
recooked15268243recooked
recopied1339843recopied
recorded122511063recorded
recorked15239853recorked
recounted1238713recounted
recouped13128663recouped
recrated112918603recrated
redacted12410243redacted
redated93120923re_dated
redocked16206823redocked
redonned10297103redonned
reedited10310083reedited
reemitted1245943reemitted
reested82916233re_ested
reexported2043323reexported
refected142311663refected
reflated123514293reflated
refloated1347013refloated
refolded1337063refolded
reforged13268703reforged
reformed14249603reformed
refronted1336053refronted
refuted114313803re_futed
regorged11227333regorged
regrated102816333regrated
regretted1137233regretted
reheated122415003reheated
rehoused1239613rehoused
reimported1543783reimported
rejected182710113rejected
rejoiced18296923rejoiced
rejoined16318593rejoined
reknitted1444023reknitted
related83327573re_lated
relented92614943relented
reletter81311023reletter
relisted9312623relisted
reloaded1059103reloaded
reloaned939723reloaned
relocated12710813relocated
relocked15217743relocked
relooked13236653relooked
relucted1138653relucted
remated103522473re_mated
remelted11310153remelted
reminted113615083reminted
remitter102810323remitter
remolded1237403remolded
remote84222603remo_te_
remoter94815973remo_ter
remotes94521613remo_tes
remounted1236283remounted
removed134611313remo_ved
renested92212953renested
renovated1347173renovated
renowned1235983renowned
rented74426593re__nted
reoiled84316853re_oiled
reopened1138513reopened
repacked17188743repacked
repainted1277863repainted
repaired1148953repaired
reparked15208923reparked
repartee10312753repartee
repassed11229273repassed
repatched1745313repatched
repattern1143663repattern
repaved133311133rep_aved
repealed113211873repealed
repeater102615443repeater
repegged1334893repegged
repelled113111593repelled
repenter102813863repenter
repeopled1444383repeopled
reperked15177793reperked
repetend1136223repetend
repined104918773rep_ined
repinned1157473repinned
replaced133211403replaced
replanted1248063replanted
replate93420053replate_
replates102919273replates
replayed14248633replayed
repled93319783rep__led
replete92912993replete_
repletes102812473repletes
replied103914453rep_lied
replowed14127573replowed
report85326023report__
reportedly1643213reportedly
reporters1139173reporters
reports94916213report_s
repose84121413repo_se_
reposer93715333repo_ser
reposes94021263repo_ses
repot75132623repo_t__
repots85621003repo_t_s
repotting12511123repotting
repower12329883repo_wer
repowered1544663repowered
repped114616723rep__ped
repriced132610543repriced
reprinted1289043reprinted
reprised112012203reprised
reprobated1546383reprobated
reprobed13228743reprobed
reproved14199473reproved
repugned1235363repugned
repulsed1136563repulsed
repumped1534383repumped
repute84716093rep_ute_
reputes94615963rep_utes
requited18169723requited
rerented92516163rerented
rerolled93010053rerolled
reroofed1235873reroofed
reroute7313963reroute_
reroutes8312223reroutes
reseated93220263reseated
resected112514743resected
resented92716963resented
resetter81511833resetter
resettled1035303resettled
resifted12310153resifted
resisted9312693resisted
resited85122423re_sited
reslated93517523reslated
resoaked1337943resoaked
resodded1136353resodded
resoften1145443resoften
resoled84119283reso_led
resolved12349343resolved
resonated10510613resonated
resorbed1138533resorbed
resorter8312183resorter
resowed113712253reso_wed
respected1438493respected
respited11410813respited
responded1336513responded
respooled1245593respooled
resprouted1344223resprouted
restated93120183restated
rested74430783re__sted
restoked135710533restoked
restored96417193restored
resulted939713resulted
retasted92412113retasted
retested92212533retested
retied75924983re__tied
retinted94414363retinted
retitled9339553retitled
retooled938473retooled
retorter8410733retorter
retotaled1045953retotaled
reunited939713reunited
reutter71010093re_utter
reverted122714713reverted
revested122612243revested
revoiced14317873revoiced
revoked154410523revo_ked
revolter11279363revolter
revolved15328103revolved
revote94917453revo_te_
revotes104716393revo_tes
reworded13228103reworded
reworked16247773reworked
rezoned173611163rezo_ned
rioted73416373r_io_ted
riposte9269623riposte_
ripostes10239083ripostes
rivetted12226093rivetted
roosted83211883r_oosted
rooted75424003r__ooted
rootled83410533r_ootled
rotated82715293r__otated
rotte54625933r__otte_
rotten64115433r__otten
rotter64325463r__otter
rottes64524833r__ottes
routed75624333r__outed
rutted74518403r__utted
shotted113912403_shotted
slotted84613883_slotted
sotted74121403__sotted
spatted104014143_spatted
spitted103912703_spitted
sported104015433_sported
spotter94514883_spotter
spouted103412263_spouted
stotted83511423_stotted
swotted11398713_swotted
totted74319953__totted
trotted83711283_trotted
undotted1048523undotted
unpitted1148623unpitted
unposted1159433unposted
unreported1344073unreported
unspotted1244933unspotted
vetted104316323ve__tted
wetted103717023we__tted
wotted104115713__wotted

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 Filter1786911461620.440406115.9
2DLD Change Limit1461623216.79621507.1
3Display Results3213210.1232609.8
 (SQL Overall)1786913217.35924282.0
 
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.