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

121 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
regulars93625(None) 
regular838421regular_
irregulars1151942irregulars
jugulars1643232jugulars
regalers94311132regalers
regears83012462reg_ears
regularly1344182regularly
regulate9313022regulate
regulates101211722regulates
regulators1146502regulators
regulus836522regul_us
seculars10219392seculars
tegular836602tegular_
angular838533angular_
arugulas943913arugula_s
beggars11378223beg_gars
beglads11127263beg_lads
beguilers1252883beguilers
begulfs1333753begul_fs
cedulas1058503cedula_s
cellars93713693ce_llars
cellulars1144133cellulars
desugars1043373desugars
eggars8398973_eg_gars
ferulas103110753ferula_s
feuars938653fe_u_ars
frenular1144633frenular_
guars65021053__gu_ars
gulags837543__gulags
gular6314833__gular_
insulars8137323insulars
irregular1052573irregular_
jaguars1535233jagu_ars
jugular1534513jugular_
kegelers1355163kegelers
keglers12277773keg_lers
ligular8348533ligular_
ligulas8329173ligula_s
medlars10259443me_dlars
megabars1344403megabars
modulars1165833modulars
nebular956483nebular_
nebulas957583nebula_s
oculars948363_oculars
peculiars1343453peculiars
pedlars103210213pe_dlars
premolars1345023premolars
radular837833radular_
radulas839583radula_s
raglans82410133rag_lans
ranular739433ranular_
ranulas7311773ranula_s
realgars934533realgars
rears54739653re___ars
rebars84019833re__bars
rebukers14435683rebukers
reclads1049993re_clads
recolors1078813recolors
recurs83315803recu__rs
recusals1056393recusals
redears82814453re_dears
reducers1147263reducers
reelers73520273re_elers
reflags1156953re_flags
refusals1164913refusals
refusers11499273refusers
refutals1165503refutals
refuters11449613refuters
regaler83814623regaler_
regales83520793regal_es
regard85215773reg__ard
regards94112563reg__ards
regear73512743reg_ear_
regelate9312083regelate
regelates10311113regelates
reggaes948883reg_gaes
regilds996673regil_ds
reginas85614063regina_s
reglaze1747223reg_laze
reglazes1846793reg_lazes
reglets83512983reg_lets
regloss8218023reg_loss
reglows11288843reg_lows
reglues838713reg_lues
regulable1246513regulable
regularity1454043regularity
regularize2045313regularize
regularizes2144793regularizes
regulated11310463regulated
regulator1046973regulator
regulatory1445293regulatory
reguli738143regul__i
reguline939503reguline
reguluses1044253reguluses
rehears103312773re_hears
relays94316753re__lays
remudas1035833remuda_s
replans92814943re_plans
replays12399763re_plays
repulsers1144713repulsers
repulses1038393repulses
results739833resul_ts
resumers1038083resumers
retears72814923re_tears
revelers113414133revelers
revilers114011693revilers
rewears102911043re_wears
rugolas836373rugola_s
rulers64317093r__ulers
secular92211533secular_
seggars9377783seg_gars
simulars1047073simulars
singulars10305633singulars
teguas768013tegu_a_s
tegularly1342993tegularly
templars1255263templars
titulars845863titulars
ungular836773ungular_
uvulars1044413_uvulars
velars93913723ve__lars
venular1037683venular_

Search took 10 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.843211970.3
2DLD Change Limit1461621218.90616411.6
3Display Results1211210.0631920.6
 (SQL Overall)1786911219.81218211.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.