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

251 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
replants10281124(None) 
replans92814941replan_s
replant93318531replant_
deplanes11311212deplanes
explants1737022explants
gelants82611442ge_lants
gellants9308282gellants
implants1237882implants
pieplants1355432pieplants
plants84921802__plants
preplans1249612preplan_s
preplant12712912preplant_
recants93217092re_cants
regrants9310012regrants
reimplants1483532reimplants
relands85214882re_lands
relents74018502re_lents
remnants1036842remnants
repaints1038482repaints
repasts93611932rep_asts
repeats94316062repea_ts
repellants1244172repellants
repents93717622rep_ents
replaces123114122replaces
replan83215822replan__
replanted1248062replanted
replate93420052repla_te
replates102919282replates
replays12399762repla_ys
replots93412632repl_ots
reprints1039902reprints
reptant92817072reptant_
sealants82610742sealants
alants67722023__alants
ashplants1443533ashplants
bepaints1235113bepaints
bezants1877343be_zants
bezzants1843643bezzants
biplanes1238573biplanes
callants104112143callants
coolants1039943coolants
croplands1445373croplands
decants103514443de_cants
depaints1136643depaints
departs104310683dep_arts
deplane10311413deplan_e
deplaned1238663deplaned
descants112910143descants
deviants1236743deviants
diplonts1146473diplonts
displants1248073displants
dopants1038433dop_ants
eclats8313033_ecla_ts
eggplants1342753eggplants
elands74914773_e_lands
elans55527753_e_lan_s
elephants1444803elephants
elints65816423_e_lints
eluants737583_eluants
emplanes1239503emplanes
enplanes1039483enplanes
epacts105010393_ep_acts
errants7410643_errants
explant16310133explant_
fenlands1245183fenlands
gallants93310373gallants
gelant72821673ge_lant_
gellant83214053gellant_
haplonts1345773haplonts
hepcats1436473hepca_ts
heptanes1339003heptanes
implant11311333implant_
leadplants1352593leadplants
levants1037723le_vants
mediants11299493mediants
misplants1347313misplants
operants1039483operants
overplants15227333overplants
pants76536923__p_ants
peasants1038263peasants
pedants10310113pe_dants
pendants1139093pendants
pennants1037063pennants
pieplant1268733pieplant_
plaints94012063__plaints
plaits83816473__plaits
planes85028083__planes
planets93914083__planets
planks124116753__planks
plans75731273__plan_s
plant75437113__plant_
plats75531373__pla_ts
preplaces1578753preplaces
preplan1149953preplan__
preprints1347473preprints
radiants9259453radiants
raglans82410133raglan_s
rants55935343r___ants
reactants1146623reactants
reacts83616603re__acts
readapts1145583readapts
reagents959623reagents
realists83014843realists
reallots837993reallots
rebaits9312583re_baits
reblends1135293reblends
reblent9614253reblent_
reboant9315093reboant_
recanes93222263re_canes
recant83228683re_cant_
recasts93413533re_casts
recharts1337663recharts
reclads1049993recla_ds
reclaims1236113reclaims
reclames12310893reclames
reclasps1235053reclasps
recleans1037513reclean_s
reclines103718543reclines
recoats92616653recoa_ts
recounts1038773recounts
recreants1146623recreants
recusants1145103recusants
redacts10510943re_dacts
redans75421023re_dan_s
redbaits1135903redbaits
redlines93916083redlines
redrafts1235603redrafts
reelects103110883reelects
reelings94012563reelings
reenacts1036993reenacts
reflags1156953refla_gs
reflate103516263refla_te
reflates113115673reflates
reflects13288873reflects
reflets103513153refl_ets
refloats1156913refloats
refracts13137383refracts
refronts1137773refronts
regents83416543re_gents
reglazes1846793reglazes
reglets83512983regl_ets
regnant8312843regnant_
regrafts1235303regrafts
regrant8317323regrant_
rehangs1137563re_hangs
reheats104513533rehea_ts
reimplant1395303reimplant_
relaces93420883re_laces
reland75920433re_lan_d
relate64033633re_la_te
relates73731443re_lates
relaxants1643243relaxants
relaxes143215323re_laxes
relays94316753re_la_ys
relends84013253re_lends
relent64431853re_lent_
relets64025673re_l_ets
reliant7319243reliant_
relicts94414603re_licts
relines75331323re_lines
relinks114510223re_links
relists73817063re_lists
rellenos8125493rellenos
reloans7313133reloan_s
relucts9369673re_lucts
remands104914883re_mands
remans84823003re_man_s
remints95117303re_mints
remnant9312643remnant_
remounts1036373remounts
rents55935183re___nts
repacks15269543rep_acks
repaint9318363repaint_
repairs9319973rep_airs
repand95316063rep_an_d
repanel939963rep_anel
repanels1036783rep_anels
reparks13249513rep_arks
repass84114703rep_a_ss
repast83520633rep_ast_
repaves123513653rep_aves
repays113813973rep_a_ys
repeals94014533repea_ls
repeat85127213repea_t_
repellant1146823repellant_
repellents1245143repellents
repent84728873rep_ent_
repines94927383rep_ines
repins84924313rep_in_s
replace113214283repla_ce
replaced133211403replaced
replacer12279743replacer
replacers13266833replacers
replanned1235163replanned
replanting1338523replanting
replaster1136583replaster
replasters1245533replasters
replated112817523replated
replay113412923repla__y
replayed14248633replayed
repleads11357213repleads
replenish1445163replenish
replete92912993repl_ete
repletes102812473repletes
replicas1237093replicas
repliers103710163repliers
replies94521043repl_ies
replot83818593repl_ot_
replows12329703repl_ows
replumbs1442183replumbs
replunge1143963replunge
replunges1243663replunges
reports94916213rep_orts
reposits10310453reposits
repots85621003rep__ots
reprint9318983reprint_
repugns1035393repugn_s
rerents73319423re_rents
reseats74319593resea_ts
resents74221223re_sents
reslate73520593resla_te
reslates83619513reslates
resonants946693resonants
resplits1037723respl_its
restarts8310873restarts
resultants1044233resultants
retints74717023re_tints
retirants947323retirants
retracts101111313retracts
revenants1246173revenants
rimlands1145243rimlands
sealant73118303sealant_
seaplanes1148723seaplanes
seawants11337973seawants
secants93413893se_cants
servants1138003servants
sextants15287383sextants
slants64819083__slants
splats84817303_spla_ts
splents93912133_splents
splints94511743_splints
supplants1344873supplants
tenants7311013te_nants
trepangs11205403trep_angs
trepans92311593trep_an_s
triplanes1148803triplanes
unplaits1044813unplaits
uplands1036943_uplands
versants1137783versants
waxplants21142803waxplants
wetlands1244763wetlands

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.436409841.7
2DLD Change Limit1461622516.95321021.4
3Display Results2512510.0962614.6
 (SQL Overall)1786912517.48523873.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.