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

116 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
replotted123582(None) 
repotted1139281rep_otted
coplotted1444792coplotted
plotted104612372__plotted
reallotted1142992reallotted
reclothed1544592reclothed
refloated1347012refloated
reknotted1443512reknotted
replanted1248062replanted
replated112817512repl_ated
replowed14127562replo_wed
reported11312702rep_orted
respotted1235952respotted
allotted986873_allotted
beclothed1744123beclothed
bedotted1234983be_dotted
beknotted1642343beknotted
besotted1135843be_sotted
blotted103911833__blotted
clotted104011823__clotted
complotted1743733complotted
depleted12258713depl_eted
deplored1237223deplo_red
deployed1535903deplo_yed
deported1249703dep_orted
exploited1944673exploited
lotted74222403___lotted
outplotted1343193outplotted
overplotted1743903overplotted
platted103614263__platted
plotter94113663__plotter
plotzed19376223__plotzed
potted94624013__p_otted
preallotted1451783preallotted
readopted1344913readopted
rebloomed1453283rebloomed
rebooted11248463re_booted
rebottled1243433re_bottled
rebutted11126783re_butted
reclothe1345733reclothe_
reclothes1445643reclothes
recoated113416783re_coated
reelected1238313reelected
reemitted1245943reemitted
refitted12309413re_fitted
reflated123514293refl_ated
reflected1547983reflected
reflooded1443553reflooded
reflowed15126903reflo_wed
refronted1336053refronted
reglossed1144003reglossed
reglowed13125853reglo_wed
regretted1137233regretted
reknitted1444023reknitted
related83327573re_l_ated
relented92614943re_lented
reletter81311023re_letter
relisted9312623re_listed
reloaded1059103re_loaded
reloaned939723re_loaned
relocated12710813re_located
relocked15217743re_locked
relooked13236653re_looked
relucted1138653re_lucted
remitted113312073re_mitted
repainted1277863repainted
repasted112611533rep_asted
repeated113117443rep_eated
repented112614983rep_ented
repeopled1444383repeopled
replaced133211393repl_aced
replanned1235163replanned
replaster1136583replaster
replate93420053repl_ate_
replates102919273repl_ates
replayed14248623repl_ayed
repleaded1336283repleaded
repled93319773repl___ed
repledged1443613repledged
replete92912983repl_ete_
repletes102812463repl_etes
replevied1574363replevied
replicated1548773replicated
replied103914443repl__ied
replot83818593replo_t__
replots93412633replo_t_s
replotting1357043replotting
replumbed1682283replumbed
replunged1343383replunged
repolled11359623rep_olled
reporter10411423rep_orter
reposed103616273rep_o_sed
reposited1239133reposited
repoured1139563rep_oured
reprinted1289043reprinted
reprobated1546383reprobated
reprobed13228743repro_bed
reproved14199473repro_ved
reputed104613483rep__uted
rerouted9311143re_routed
reslated93517523resl_ated
resorted9313493re_sorted
resprouted1344223resprouted
retorted9312333re_torted
retted74826313re___tted
revetted122210943re_vetted
revolted12319863re_volted
revoted114314153re_vo_ted
rewetted12228353re_wetted
riposted11216933rip_osted
rotted74524433r___otted
rouletted1045053rouletted
slotted84613883__slotted
splatted11356743_splatted
spotted103713143_sp_otted
unpotted11108393unp_otted

Search took 9 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.1701051123.5
2DLD Change Limit1486411167.92318760.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.13921954.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.