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 “regatta” 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
regatta83596(None) 
regattas944471regattas
reata54225392re_a_ta
regalia839222regalia
regmata1036192regmata
begat86629723bega_t_
bemata10411693bema_ta
beretta938463beretta
betta74916843be__tta
bregmata1343203bregmata
egesta7428653_egesta
ergate7315143erga_te
ergates8314493ergates
errata639013erra_ta
exacta15337393_exacta
gutta64613383__gutta
legate72917453lega_te
legated92513983legated
legatee82814633legatee
legates82917683legates
legato72810953lega_to
legator83011133legator
legatos82711183legatos
megara9310093mega_ra
megastar1143533megastar
megaton10269853megaton
negate72915573nega_te
negated93413233negated
negater83711963negater
negates83215843negates
negaton8299143negaton
negator83010673negator
raita54623073r__aita
ratatat7412263ratatat
rattan63613603r__attan
ratty84819593r__atty
react74634333re_act_
reacts83616603re_acts
realia6314593re_alia
realty92713693re_alty
reatas64021013re_atas
reattach1343743re_attach
reattack1444123re_attack
reattain846733re_attain
rebait8320403rebait_
rebaits9312573rebaits
rebate84424113reba_te
rebated103619703rebated
rebater93517913rebater
rebates95123183rebates
rebato83714683reba_to
rebatos92913113rebatos
rebuttal1043993rebuttal
recant83228683recant_
recants93217093recants
recast83422773recast_
recasts93413533recasts
recta74220263re__cta
redact9419043redact_
redacts10510943redacts
redate74124683reda_te
redated93120923redated
redates83423873redates
regain74517763rega_in
regains84316583regains
regal65023793rega__l
regale74821453rega_le
regaled93615963regaled
regaler83814623regaler
regales83520793regales
regality1249313regality
regally1159873regally
regard85215773rega_rd
regards94112563regards
regather1236733regather
regauge945813regauge
regave104713383rega_ve
regent74127673regent_
regental948943regental
regents83416543regents
regilt71217493regilt_
regina75317143reg_ina
reglet73724233reglet_
reglets83512983reglets
regma84612333reg__ma
regna64614813reg__na
regnant8312843regnant_
regraft11310153regraft_
regrafts1235303regrafts
regrant8317323regrant_
regrants9310013regrants
regrate82618663regrate
regrated102816333regrated
regrates92618393regrates
regret73723533regret_
regrets83212923regrets
relate64033633rela_te
related83327573related
relater73723143relater
relates73731433relates
relator74016363relator
rematch1436193rematch
remate84428683rema_te
remated103522473remated
remates93827113remates
remittal1046513remittal
repast83520633repast_
repasts93611933repasts
repatch1435843repatch
resat55139683resa_t_
restate73824883restate
retaste72313133retaste
retia55326113re__tia
riata54618023r_ia_ta
ricotta955433ricotta
rugate75813813ruga_te

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.1561145455.1
2DLD Change Limit1340271166.59620319.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.79826285.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.