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

277 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
reginal8481429(None) 
regina75317141regina_
reginae84713451reginae
reginas85614061reginas
regional9438781regional
regnal74812931reg_nal
retinal75318351retinal
anginal8310162anginal
geminal10109902geminal
original956792original
paginal10269492paginal
recital9412162recital
redial74923112redi_al
regal65023792reg__al
regental948942regental
regionals10286412regionals
regna64614812reg_na_
renal55929502re__nal
retial64724992reti_al
retina65023382retina_
retinae75517332retinae
retinals85612962retinals
retinas74819352retinas
retinol7469692retinol
revisal1038262revisal
revival1337032revival
rhinal9510192r_hinal
ruminal9289992ruminal
seminal91213402seminal
tegminal1144452tegminal
vaginal11288402vaginal
veinal93812962ve_inal
actinal9312293actinal
aecial84817313aeci_al
aerial64625713aeri_al
affinal1336443affinal
agonal7410053_agonal
albinal937813albinal
angina7413133angina_
anginas8310953anginas
basinal9310033basinal
begin85117353begin__
begins94415303begin_s
binal75323823__binal
carinal94318233carinal
clinal8311553_clinal
criminal1248303criminal
decanal1038113decanal
decimal1238083decimal
denial74720513deni_al
dentinal939503dentinal
devisal1136913devisal
digital937063digital
egal55119433_eg__al
encinal949243encinal
epical10413393_epical
fecial114714623feci_al
ferial94621253feri_al
fetial95716193feti_al
final83922033__final
genial74917613geni_al
genital849793genital
geoidal936703geoidal
germinal1147253germinal
gingal81010153__gingal
gremial1039153gremi_al
hegira1036523hegira_
hegiras1136103hegiras
helical12311153helical
hernial10310433hernial
imaginal1144903imaginal
inguinal945603inguinal
irenical1048553irenical
jejunal1342833jejunal
laminal94113633laminal
legal65715943leg__al
lexical1637363lexical
liminal93810673liminal
logical1038513logical
luminal93711003luminal
magical1239783magical
marginal1137603marginal
matinal9312603matinal
medial93819863medi_al
medical12312513medical
medina94114093medina_
medinas103411463medinas
megilla1036273megilla
menial84223033meni_al
mesial84818083mesi_al
metical11315363metical
nominal92712373nominal
oedipal1045173oedipal
ogival1035873_ogival
ordinal838633ordinal
originals1044843originals
penal75228373pe__nal
penial84120893peni_al
perineal1049183perineal
preanal9310713pre_anal
predial103815413predi_al
prefixal2044543prefixal
prerenal1049083prerenal
presignal12105553presignal
racial83419243raci_al
radial74020393radi_al
radical103312793radical
raging85126433ragin_g
ragingly1337863ragingly
rational8412543rational
reagin74915533reagin__
reaginic1144453reaginic
reagins84215643reagin_s
real45750293re___al
rebill84713253rebi_ll
rebind94416933rebin_d
rebinds104511873rebinds
recitals1039763recitals
recoal84117973re_coal
rectal84418133re_ctal
recusal968673recusal
redia65524483redi_a_
rediae74221993redi_ae
redials84416883redi_als
redias74523603redi_as
reding83825563redin_g
refill94514053refi_ll
refinable1438623refinable
refind104717073refin_d
refinds114512123refinds
refine95225693refin_e
refined114720003refined
refiner105316913refiner
refines105426343refines
refusal1056893refusal
refutal1046943refutal
regain74517763regain__
regained102111243regained
regainer9249353regainer
regains84316583regain_s
regale74821453reg__ale
regear73512743reg_ear
regency1337363regency
regent74127673regen_t
regents83416543regents
reggae858953reg_gae
regicidal1343733regicidal
regild8149773regi_ld
regilds996673regilds
regilt71217493regi_lt
regime95313943regi_me
regimen104411573regimen
regimental13115763regimental
regimes104514743regimes
region74614903regi_on
regionally1445533regionally
regions83613473regions
regius7311923regi_us
regive104814323regi_ve
regiven11478323regiven
regives115014213regives
regma84612333reg_ma_
regnant8312843reg_nant
regnum957163reg_num
regosol844883regosol
regrant8317323regrant
regrind938983regrin_d
regrinds1035533regrinds
regular838423regular
rehinge1148503rehinge
reign65015193reign__
reigned949213reigned
reigns74811753reign_s
rein46040893re_in__
reined74425523re_ined
reink95518093re_in_k
reinks105012153re_inks
reins56234563re_in_s
rekindle1344643rekindle
reliant7319243reliant
reline65434353relin_e
relined85321933relined
relines75331323relines
relink104415923relin_k
relinks114510223relinks
remigial1146603remigial
remind94819793remin_d
reminds104614793reminds
remint85329973remin_t
remints95117293remints
remittal1046513remittal
removal1236733removal
renail65020763re__nail
renewal1038703renewal
renin54830033renin__
renins64526453renin_s
rental63922023re_ntal
reoil55321183reoi__l
repanel939963repanel
repeal84718283re_peal
repin75324703repin__
repine85627813repin_e
repined104918773repined
repiner94816903repiner
repines94927383repines
repins84924313repin_s
reposal939113reposal
reprisal1045903reprisal
requital1745053requital
reseal64819643re_seal
residual9245443residual
resin54131053resin__
resinate8316773resinate
resined84522653resined
resins64528773resin_s
resiny94617363resin_y
retia55326113reti_a_
retine66237333retin_e
retines75134673retines
retinols8419743retinols
retint65633443retin_t
retints74717013retints
retinue75414843retinue
retinula845723retinula
retotal739843retotal
retral64419743re_tral
retrial7615553retrial
retsina74710603retsina_
retsinas8387963retsinas
reveal94115053re_veal
revenual1144783revenual
reviewal1443513reviewal
revisals1136813revisals
revivals1435433revivals
rewin85623963rewin__
rewind104715883rewin_d
rewinds114810483rewinds
rewins95020823rewin_s
rexine134719443rexin_e
rexines144719153rexines
rial45938093r__i_al
rival85216503r__ival
riyal84413433r__iyal
rosinol756323rosinol
rugal65916093rug__al
rumina83412483rumina_
seconal9310073seconal
segetal868383segetal
semina8915563semina_
seminar979753seminar
serial64625853seri_al
signal73711483sig_nal
spinal84915313_spinal
tegmina1035243tegmina_
telial65815363teli_al
terminal1039723terminal
tetanal738023tetanal
tragical1148213tragical
trigonal946243trigonal
trinal6516963_trinal
uncinal959963uncinal
uredial82910483uredi_al
uredinial1043913uredinial
urinal6614123_urinal
vagina102710933vagina_
vaginae11377683vaginae
vaginas11298813vaginas
vegetal1156303vegetal
venal85523213ve__nal
venial94218283veni_al
vernal93514213ve_rnal
vesical12159813vesical
vicinal12268543vicinal
viminal12288823viminal
vinal85725813__vinal
virginal1244573virginal
xenial133414903xeni_al

Search took 9 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.1731032896.0
2DLD Change Limit1340272777.73317331.8
3Display Results2772770.0932978.5
 (SQL Overall)1786912777.99922339.2
 
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.