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

131 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
regmata103619(None) 
bregmata1343201bregmata
bemata10411692be_mata
bregmate1345532bregmate
dogmata1145142dogmata
fermata12278142fermata
lemmata1144672lemmata
magmata1237462magmata
reata54225392re__ata
regatta835962regatta
regma84612332regm__a
regrate82618662regrate
remate84428682re_mate
agemate101210583agemate
bedmate1239433bedmate
begat86629723beg_at_
bregma1134963bregm__a
bregmatic1644073bregmatic
celomata1296633celomata
commata1338483commata
cremate113816183cre_mate
crewmate15405633crewmate
edemata1046003edemata
egesta7428653_egesta
enemata948013enemata
enigmata1143663enigmata
ergate7315143erg_ate
errata639013_errata
fermatas13246223fermatas
fermate122813003fermate
gemmate12418383gemmate
gummata1244613gummata
hematal1238953he_matal
kerygmata1951313kerygmata
legate72917453leg_ate
legato72810953leg_ato
legman949653legma_n
megara9310093meg_ara
myomata1445923myomata
negate72915573neg_ate
oedemata1143853oedemata
ragman94013713ragma_n
ramada9310183r_amada
ramate83921693r_amate
reatas64021013re__atas
rebate84424113re_bate
rebato83714683re_bato
recoat84024273recoat_
recoats92616643recoats
recrate92621663recrate
recta74220263re__cta
redate74124683re_date
reemit8717223reemit_
reemits9611303reemits
reflate103516263reflate
regain74517763reg_ain
regal65023793reg_a_l
regale74821453reg_ale
regalia839223regalia
regard85215773reg_ard
regattas944473regattas
regave104713383reg_ave
regear73512743regea_r
regears83012463regears
regelate9312083regelate
regent74127673regent_
regental948943regental
regents83416543regents
reggae858953regga_e
reggaes948883reggaes
regilt71217493regilt_
regina75317143reg_ina
reglaze1747223reglaze
reglet73724233reglet_
reglets83512983reglets
regna64614813reg__na
regnal74812933regna_l
regnant8312843regnant
regrade92612033regrade
regraft11310153regraft
regrafts1235303regrafts
regrant8317323regrant
regrants9310013regrants
regrated102816333regrated
regrates92618403regrates
regret73723533regret_
regrets83212923regrets
regulate9313023regulate
reheat94423943reheat_
reheats104513523reheats
reimage1037913reimage
relate64033633re_late
remade94316983re_made
remail85017123re_mail
remain85919863re_main
remake124016113re_make
reman75730153re_ma_n
remand95618963re_mand
remans84823003re_mans
remap95418103re_ma_p
remaps105012873re_maps
remark123512373re_mark
rematch1436193re_match
remated103522473re_mated
remates93827113re_mates
remet74843723re_met_
remit75737223re_mit_
remits85622943re_mits
remora8414593re_mora
remote84222603re_mote
remuda936823re_muda
repeat85127213repeat_
repeats94316053repeats
replate93420053replate
resat55139683re_sat_
reseat64131493reseat_
reseats74319583reseats
reslate73520593reslate
restate73824883restate
riata54618023r__iata
rugate75813813rug_ate
sigmate10710143sigmate
somata8312383_somata
stemmata1244213stemmata
stigmata1144673stigmata
stomata938533stomata
tegmenta1155613tegmenta
tegmina1035243tegmina
traumata1045693traumata
trymata1244223trymata
zygomata2342843zygomata

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271317.06318975.9
3Display Results1311310.0632079.4
 (SQL Overall)1786911317.53223724.2
 
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.