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

288 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
regrant831732(None) 
regnant8312841regnant
regraft11310151regraft
regrants9310011regrants
errant6618732_errant
fragrant1247112fragrant
grant64840022__grant
migrant10314312migrant
pregnant1149882pregnant
reboant9315092reboant
recant83228682re_cant
recreant10311282recreant
redraft11310572redraft
refract121311602refract
refront10313262refront
regardant1145442regardant
regent74127672reg_ent
regrade92612032regrade
regrafts1235302regrafts
regranted1137702regranted
regrate82618662regrate
regreet83015952regreet
regret73723532regr_et
regrind938982regrind
reliant7319242reliant
remnant9312642remnant
replant93318532replant
reprint9318982reprint
reptant92817072reptant
reran57329102re_ran_
rerent63832452re_rent
retirant8313592retirant
retract91318112retract
rewrapt12138112rewrapt
vagrant11410662vagrant
aberrant1049543aberrant
arrant6623253_arrant
began86319573beg_an_
begat86629723beg_a_t
begroan1036103begroan_
begroans1145503begroans
bewrapt14147133bewrapt
bezant17814543be_zant
bezzant1746893bezzant
brant74742173__brant
courant9317973courant
currant9314173currant
decant93524223de_cant
defiant11311923defiant
degrade10229903degrade
derat65044083de_ra_t
descant104315593descant
detract101414633detract
deviant11311313deviant
egret63327313_egr_et
elegant8311503eleg_ant
eluant6315093_eluant
emigrant1148563emigrant
engraft11118623engraft
enrapt8313013_enrapt
entrant7318873entrant
errand758793_errand
errants7410643_errants
extant132714753_extant
figurant1246723figurant
flagrant1247633flagrant
gelant72821673ge_lant
gellant83214053gellant
gerent73223103ge_rent
giant65430593__giant
graft95327203__graft
gran56335013__gran_
grana65722093__grana
grand75122693__grand
grans64832543__grans
grants73722473__grants
grat55651283__gra_t
grunt65523543__grunt
hydrant1489053hydrant
inerrant8412493inerrant
ingraft1199503ingraft
integrant1049833integrant
intrant7318753intrant
iterant7317783iterant
jessant1438443jessant
jurant134216553_jurant
leant56737783le__ant
learnt64019253lear_nt
legman949653legman_
levant9314493le_vant
meant76537213me__ant
mediant103516703mediant
migrants1138183migrants
negroni846843negroni
odorant8411393odorant
operant9317223operant
oregano846253oreg_ano
pageant10312783pageant
peasant9314923peasant
peccant13311733peccant
pedant9319493pe_dant
pendant10314853pendant
pennant9312493pennant
predraft1447593predraft
prefrank1764233prefrank
preplant12712913preplant
preprint12314183preprint
radiant82817133radiant
raglan73711503raglan_
raglans82410133raglans
ragman94013713ragman_
rampant11312173rampant
rant45864683___rant
react74634333re__act
reactant10311433reactant
readapt1039743readapt
reagent8716603reagent
rearing83128783rearing
rebait8320403re_bait
reblent9614253reblent
rebranch1545813rebranch
recane83022873re_cane
recants93217093re_cants
recast83422773re_cast
recent83630853re_cent
rechart12314343rechart
recoat84024273recoa_t
recount9315173recount
recrate92621663recrate
recreants1146623recreants
recruit939773recruit
recusant1049463recusant
redact9419043re_dact
redan66125013re_dan_
redans75421023re_dans
redbait1039803redbait
redrafts1235603redrafts
redraw10269853redra_w
redrawn11245953redrawn
redraws11218473redraws
redreamt11127183redreamt
redroot8312903redroot
reearn6612143reearn_
reearns749103reearns
reenact9413013reenact
reentrant947843reentrant
reerect92915883reerect
referent112813423referent
refracts13137383refracts
refrain10310043refrain
refrains1139593refrains
reframe1239393reframe
refronts1137773refronts
regain74517763reg_ain
regains84316583regains
regal65023793reg_a_l
regale74821453reg_ale
regard85215773reg_ard
regards94112563regards
regatta835963reg_atta
regave104713383reg_ave
regear73512743regea_r
regears83012463regears
regents83416543reg_ents
reggae858953regga_e
reggaes948883reggaes
regilt71217493reg_ilt
regiment114414053regiment
regina75317143reg_ina
reginae84713453reginae
reginal84814293reginal
reginas85614063reginas
region74614903region_
regions83613473regions
registrant1154773registrant
reglaze1747223reglaze
reglet73724233reg_let
regma84612333regma__
regmata1036193regmata
regna64614813reg__na
regnal74812933regna_l
regnancy1444773regnancy
regraded113410763regraded
regrades103212173regrades
regrading121210203regrading
regrafted1435243regrafted
regranting1238323regranting
regrated102816333regrated
regrates92618403regrates
regrating111316213regrating
regreen8309043regreen
regreens9257453regreens
regreets9287853regreets
regress82711453regress
regrets83212923regrets
regrew10388563regr_ew
regrinds1035533regrinds
regroom1077303regroom
reground1045073reground
regroup1095173regroup
regrow10309883regr_ow
regrown11237363regrown
regrows11269153regrows
regrowth1544033regrowth
rehang1039823re_hang
reheat94423943rehea_t
reland75920433re_land
relaxant1545843relaxant
relearnt849213relearnt
relent64431853re_lent
relevant1149243relevant
reloan6415693reloan_
reloans7313133reloans
reman75730153re_man_
remand95618963re_mand
remans84823003re_mans
remint85329983re_mint
remnants1036843remnants
remount9512283remount
rent46661243re___nt
reorient8613473reorient
repaint9318363repaint
repand95316063re_pand
repast83520633re_past
repeat85127213repea_t
repent84728873re_pent
replan83215823replan_
replans92814943replans
replants102811243replants
reprints1039903reprints
repugnant1243853repugnant
rerack122513163re_rack
rerents73319423re_rents
rerun58722153re_run_
reruns66413743re_runs
resat55139683re_sa_t
reseat64131493resea_t
resent63833623re_sent
resonant8410813resonant
resprang11175843resprang
restart7320033restart
restraint9412753restraint
retardant1046833retardant
retint65633443re_tint
retirants947323retirants
retrace91417343retrace
retrack131310723retrack
retracts101111313retracts
retrain7615423retrain
retrains8314533retrains
retral64419743retra_l
retreat7317533retreat
retroact10410003retroact
revenant11410283revenant
reverent112615093reverent
revertant12128003revertant
rewan85623663re_wan_
rewrap11127533rewra_p
rewraps12136563rewraps
riant55833153r__iant
roborant1048383roborant
ryegrass1242793ryegrass
sealant73118303sealant
seawant103613413seawant
secant84023293se_cant
segment10312563segment
segregant1144363segregant
sejant133114483se_jant
sejeant1489723sejeant
sergeant9129403sergeant
serrano768463serrano
servant10313633servant
sextant142911963sextant
spirant9814293spirant
taggant9310223taggant
tenant6322473te_nant
terrane72814233terrane
titrant7315193titrant
tyrant9315333_tyrant
vagrants1246143vagrants
vegan95114153veg_an_
vegans103910853veg_ans
vegetant1246963vegetant
verdant11313293verdant
versant10313833versant
vibrant12410393vibrant
warrant10614243warrant
zebrano1843853zebrano

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272886.03022226.7
3Display Results2882880.0933096.8
 (SQL Overall)1786912886.52927368.8
 
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.