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

193 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
regular83842(None) 
regulars936251regulars
tegular836601tegular
angular838532angular
frenular1144632frenular
gular6314832__gular
irregular1052572irregular
jugular1534512jugular
ligular8348532ligular
nebular956482nebular
radular837832radular
ranular739432ranular
regaler83814622regaler
regear73512742reg_ear
regularly1344182regularly
regulate9313022regulate
regulator1046972regulator
reguli738142regul_i
regulus836522regulus
secular92211532secular
ungular836772ungular
venular1037682venular
alular6311353_alular
annular737693annular
areolar779223are_olar
arugula843913arugula_
arugulas943913arugulas
beggar10328223beg_gar
beglad10138463beg_lad
beguiler1154063beguiler
begulf1238903begul_f
begulfs1333753begulfs
canular9310323canular
cedula977643cedula_
cedulas1058503cedulas
cellar84514983ce_llar
cellular1045163cellular
cingular11256973cingular
copular113810603copular
cupular11317623cupular
desugar944033desugar
eggar7458883_eg_gar
fabular12288693fabular
facular122810443facular
fecula113310053fecula_
feculae12339203feculae
ferula93011173ferula_
ferulae10309603ferulae
ferulas103110753ferulas
feuar8310243fe_u_ar
fibular12267973fibular
frenula1045623frenula_
granular946893granular
guar56923293__gu_ar
gulag7310823__gulag
hamular1236973hamular
insular7138703insular
irregulars1151943irregulars
jaguar1435283jagu_ar
jocular1637303jocular
jugula1434983jugula_
jugulars1643233jugulars
kegeler1245493kegeler
kegler11398243keg_ler
ligula7359673ligula_
ligulae8308753ligulae
ligulas8329173ligulas
lingular9407503lingular
lobular936663lobular
locular938953locular
lunular736013lunular
macular113011943macular
medlar93010463me_dlar
medullar1143463medullar
megabar1244503megabar
modular1087363modular
morular978223morular
mutular936643mutular
nebula857333nebula_
nebulae955493nebulae
nebulas957583nebulas
neurular844003neurular
nodular876703nodular
ocular8610133_ocular
oracular1047533oracular
oscular937933oscular
ovular946833_ovular
pabular11259473pabular
papular11299763papular
peculiar1245453peculiar
pedlar93311273pe_dlar
pendular1144943pendular
pilular938203pilular
popular11319563popular
premolar1246633premolar
radula749313radula_
radulae837963radulae
radulas839583radulas
raglan73711503rag_lan
ranula6311813ranula_
ranulas7311783ranulas
realer63528593re_aler
realgar834873realgar
rear45644553re___ar
rebar75420193re__bar
rebuker13407843rebuker
reclad9311873re_clad
recolor978693recolor
recur74116843recu__r
recusal968683recusal
redear73515173re_dear
reducer1059003reducer
reeler63822573re_eler
reflag1098083re_flag
refusal1056893refusal
refuser104912783refuser
refutal1046943refutal
refuter104312193refuter
regal65023793reg__al
regale74821453regal_e
regaled93615963regaled
regalers94311133regalers
regales83520793regales
regalia839223regalia
regally1159873regally
regard85215773reg__ard
regears83012463reg_ears
regelate9312083regelate
reggae858953reg_gae
regild8149773regil_d
regilds996673regilds
regilt71217493regil_t
regina75317143regina_
reginae84713453reginae
reginal84814293reginal
reginas85614063reginas
reglaze1747223reg_laze
reglet73724233reg_let
reglow10339403reg_low
reglue739703reg_lue
reglued936333reglued
reglues838713reglues
regma84612333reg_ma_
regna64614813reg_na_
regnal74812933reg_nal
regulable1246513regulable
regularity1454043regularity
regularize2045313regularize
regulated11310463regulated
regulates101211723regulates
regulators1146503regulators
regulatory1445293regulatory
reguline939503reguline
rehear93713223re_hear
relax124817803re__lax
relay84424673re__lay
remuda936823remuda_
remudas1035833remudas
replan83215823re_plan
replay113412923re_play
repulse938193repulse
repulser1035803repulser
result6318223resul_t
results739833results
resumer9410113resumer
retear63115483re_tear
reticular1147113reticular
retinular944763retinular
reveler104116343reveler
reviler104314973reviler
rewear93012003re_wear
rugola736293rugola_
rugolas836373rugolas
ruler54923343r__uler
seculars10219393seculars
seggar8357813seg_gar
simular938673simular
singular9327563singular
specular12217613specular
tabular9279763tabular
tegua6109563tegu_a_
teguas768013tegu_as
tegularly1342993tegularly
templar1145643templar
titular737523titular
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungula737603ungula_
ungulae837313ungulae
uvular955563_uvular
velar85817633ve__lar
zonular1656493zonular

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.423422437.4
2DLD Change Limit1340271937.09318895.7
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.59223536.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.