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

213 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
regnant831284(None) 
pregnant1149881pregnant
regrant8317321regrant
remnant9312631remnant
pennant9312492pennant
reboant9315092reboant
recant83228682re_cant
reenact9413002reenact
regent74127672reg_ent
regna64614812regna__
regnal74812932regna_l
regnancy1444772regnancy
regraft11310152regraft
regrants9310012regrants
reliant7319242reliant
remnants1036842remnants
replant93318532replant
reptant92817072reptant
repugnant1243852repugnant
resonant8410812resonant
revenant11410272revenant
tenant6322472te_nant
began86319573beg_an_
begat86629723beg_a_t
benignant1243983benignant
bezant17814543be_zant
bezzant1746893bezzant
decant93524223de_cant
defiant11311923defiant
descant104315583descant
deviant11311313deviant
elegant8311503eleg_ant
eluant6315093_eluant
emanant9411083emanant
enact73525363_e_nact
errant6618733_errant
extant132714753_extant
fragrant1247113fragrant
gelant72821673ge_lant
gellant83214053gellant
giant65430593__giant
gnat56034433__gna_t
grant64840023__grant
impregnant1553163impregnant
jessant1438443jessant
leant56737783le__ant
legman949653legman_
levant9314493le_vant
lignan75510323lignan_
lignans8398853lignans
meant76537213me__ant
mediant103516703mediant
migrant10314313migrant
oregano846253oreg_ano
pageant10312783pageant
peasant9314923peasant
peccant13311733peccant
pedant9319493pe_dant
penang92511113pe_nang
pendant10314853pendant
pennants1037063pennants
poignant1145743poignant
preenact12410183preenact
pregnancy1744063pregnancy
pregnantly1643723pregnantly
preplant12712913preplant
radiant82817133radiant
raglan73711503raglan_
raglans82410133raglans
ragman94013713ragman_
rampant11312173rampant
rant45864683r___ant
react74634333re__act
reactant10311433reactant
readapt1039743readapt
reagent8716603reagent
reanoint8413013reanoint
rebait8320403re_bait
reblent9614253reblent
recane83022873re_cane
recants93217093re_cants
recast83422773re_cast
recent83630853re_cent
rechart12314323rechart
recoat84024273recoa_t
recount9315173recount
recreant10311283recreant
recusant1049463recusant
redact9419043re_dact
redan66125013re_dan_
redans75421023re_dans
redbait1039803redbait
redraft11310573redraft
redundant1143983redundant
reenacts1036993reenacts
reentrant947833reentrant
refract121311603refract
refront10313263refront
regain74517763reg_ain
regains84316583regains
regal65023793reg_a_l
regale74821453reg_ale
regard85215773reg_ard
regardant1145443regardant
regatta835963reg_atta
regave104713383reg_ave
regear73512743regea_r
regears83012463regears
regents83416543reg_ents
reggae858953regga_e
reggaes948883reggaes
regilt71217493reg_ilt
regiment114414053regiment
regina75317143reg_ina
reginae84713453regina_e
reginal84814293regina_l
reginas85614063regina_s
region74614903region_
regions83613473regions
reglaze1747223reglaze
reglet73724233reg_let
regma84612333regma__
regmata1036193regmata
regnum957163regn_um
regrade92612033regrade
regrafts1235303regrafts
regranted1137703regranted
regrate82618663regrate
regreet83015953regreet
regret73723533reg_ret
regrind938983regrind
rehang1039823re_hang
reheat94423943rehea_t
reigning1039883reigning
reining84425323reining
reinvent1138903reinvent
reknit10312533rekn_it
reknot10311733rekn_ot
reland75920433re_land
relaxant1545843relaxant
relearnt849213relearnt
relent64431853re_lent
relevant1149243relevant
reloan6415693reloan_
reloans7313133reloans
reman75730153re_man_
remand95618963re_mand
remanent10311703remanent
remans84823003re_mans
remint85329973re_mint
remnantal1142533remnantal
remontant1148093remontant
remount9512283remount
renail65020763re_nail
renal55929503re_na_l
rename82718813re_name
renest64529713re_nest
renin54830033re_nin_
renins64526453re_nins
rennase738713rennase
rennet64624853re_nnet
rennin63914033rennin_
rennins74013413rennins
rent46661243re___nt
repaint9318363repaint
repand95316063re_pand
repast83520633re_past
repeat85127213repea_t
repent84728873re_pent
repentant1149313repentant
replan83215823replan_
replans92814943replans
replants102811243replants
reprint9318983reprint
reran57329103re_ran_
rerent63832453re_rent
resat55139683re_sa_t
reseat64131493resea_t
resent63833623re_sent
resonants946693resonants
restart7320033restart
retint65633443re_tint
retirant8313593retirant
retract91318113retract
revenants1246173revenants
rewan85623663re_wan_
rewrapt12138113rewrapt
reynard1135123reynard
riant55833153r__iant
ringent8315153ringent
ruminant1047853ruminant
sealant73118303sealant
seawant103613413seawant
secant84023293se_cant
segment10312563segment
sejant133114483se_jant
sejeant1489723sejeant
sergeant9129403sergeant
servant10313623servant
setenant849923setenant
sextant142911963sextant
sonant6621953_sonant
stagnant946893stagnant
taggant9310223taggant
tenants7311013te_nants
unpregnant1352363unpregnant
vagrant11410663vagrant
vegan95114153veg_an_
vegans103910853veg_ans
vegetant1246963vegetant
verdant11313293verdant
versant10313833versant
zenana15297983ze_nana

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.1401276364.3
2DLD Change Limit1340272136.17321711.8
3Display Results2132130.0762802.6
 (SQL Overall)1786912136.38927968.5
 
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.