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

188 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
geminal1010991(None) 
germinal1147261germinal
seminal91213411seminal
bigeminal1443262bigeminal
geminally1576402geminally
geminate11411812geminate
genial74917612geni_al
genital849792genital
geoidal936712geoidal
germina1038502germina_
gremial1039152gremi_al
laminal94113632laminal
liminal93810672liminal
luminal93711002luminal
nominal92712372nominal
reginal84814292reginal
retinal75318352retinal
ruminal9289992ruminal
semina8915572semina_
seminar979762seminar
tegminal1144452tegminal
terminal1039732terminal
veinal93812962ve_inal
viminal12288822viminal
actinal9312293actinal
admiral1046363admiral
aecial84817313aeci_al
aerial64625713aeri_al
affinal1336443affinal
albinal937813albinal
ammonal1137023ammonal
anginal8310163anginal
basinal9310033basinal
bemingle1346103bemingle
binal75323823__binal
carinal94318233carinal
chemical1748393chemical
clinal8311553_clinal
comical13312223comical
criminal1248303criminal
decanal1038113decanal
decimal1238083decimal
denial74720513deni_al
denominal1245693denominal
dentinal939503dentinal
devisal1136913devisal
domical1239373domical
encinal949243encinal
epical10413393_epical
fecial114714623feci_al
feminacy1844453feminacy
feminazi2243133feminazi
feminie12179933feminie
femoral1238723femoral
ferial94621253feri_al
fetial95716193feti_al
final83922033__final
gametal1037603gametal
gamin84423003gamin__
gamine94620153gamin_e
gamines103618463gamines
gaming104622043gamin_g
gamings114610913gamings
gamins94420053gamin_s
gavial10310083gavi_al
geeing84313773geein_g
geminated1338553geminated
geminates12310043geminates
gemma106311773gem_ma_
gemmae11507793gem_mae
gemming13289153gemmin_g
general81010933general
genipap1243123genipap
genitals937243genitals
geranial949283geranial
germinally1655253germinally
germinant1246183germinant
germinate1248633germinate
gestical1138993gestical
gimbal11228813gim_bal
gimmal11247513gim_mal
gingal81010153g__ingal
glial66715433g_li_al
gnomical1346683gnomical
gomeral1038833gomeral
gremials1136133gremi_als
helical12311153helical
hemal104419803hem__al
hematal1238953hematal
hemin103620933hemin__
hemins113417573hemin_s
hemiola12107003hemiola
hernial10310433hernial
hymenal1545183hymenal
hymnal1434913hym_nal
jejunal1342833jejunal
jemidar1744163jemidar
lamina84920443lamina_
laminae93512973laminae
laminals10339303laminals
laminar93810283laminar
laminas93615873laminas
lexical1637363lexical
limina83514503limina_
lumenal9307273lumenal
lumina84613543lumina_
matinal9312603matinal
medial93819863medi_al
medical12312513medical
medina94114093medina_
medinas103411463medinas
menial84223033meni_al
mesial84818083mesi_al
metical11315363metical
mimical1339233mimical
mina65136923__mina_
minae75627723__minae
minas75434113__minas
nomina83113683nomina_
nominals10278613nominals
numina83510843numina_
oedipal1045173oedipal
ordinal838633ordinal
paginal10269493paginal
pembina1345223pembina_
pembinas1454143pembinas
pemican1348163pemican
penal75228373pe__nal
penial84120893peni_al
perineal1049193perineal
recital9412163recital
redial74923113redi_al
regina75317143regina_
reginae84713453reginae
reginas85614063reginas
regional9438783regional
regnal74812933re_gnal
remigial1146603remigial
remind94819793remin_d
reminds104614793reminds
remint85329983remin_t
remints95117293remints
remittal1046513remittal
removal1236733removal
renal55929503re__nal
retial64724993reti_al
retina65023383retina_
retinae75517333retinae
retinals85612963retinals
retinas74819353retinas
retinol7469693retinol
revisal1038263revisal
revival1337033revival
rhinal9510193_rhinal
rumina83412483rumina_
seconal9310073seconal
semibald1344563semibald
semifinal1444703semifinal
semigala1144633semigala
semimat11412913semimat
seminally1458803seminally
seminars1079053seminars
seminary1398103seminary
semioval1346223semioval
semiraw1246053semiraw
semitonal1157043semitonal
serial64625863seri_al
somital939403somital
spinal84915313_spinal
staminal1046983staminal
tegmina1035243tegmina_
telial65815363teli_al
terminals1147453terminals
tetanal738023tetanal
trigeminal1352673trigeminal
trinal6516963_trinal
uncinal959963uncinal
urinal6614123_urinal
vaginal11288403vaginal
venal85523213ve__nal
venial94218283veni_al
vernal93514213ve_rnal
vesical12159813vesical
vicinal12268543vicinal
vimina11339943vimina_
vinal85725813__vinal
xenial133414903xeni_al
zemindar2043323zemindar

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 Limit1340271886.95319276.1
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.43524033.8
 
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.