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

112 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
geoidal93671(None) 
geminal10109902geminal
genial74917612geni_al
genital849792genital
genocidal1343912genocidal
geoid74215762geoid__
geoids8369842geoid_s
gyroidal1343692gyroidal
hyoidal1444802hyoidal
keloidal1344102keloidal
ovoidal1144022ovoidal
zooidal1745092zooidal
adenoidal1143663adenoidal
aecial84817313aeci_al
aecidial1147253aecidial
aerial64625713aeri_al
alodial899953alodial
anodal72512123ano_dal
apodal9289833apo_dal
apsidal1046703apsidal
biocidal1344943biocidal
bridal9511453_bridal
chordal13449883chordal
coital84117053_coital
conoidal1149013conoidal
cotidal1038463cotidal
cuboidal1344243cuboidal
decadal1137243decadal
decidual1244203decidual
decimal1238083decimal
dedal75719023de__dal
deicidal1245713deicidal
denial74720513deni_al
deodar837713deo_dar
devisal1136913devisal
ecocidal1354963ecocidal
epical10413393_epical
fecial114714623feci_al
ferial94621253feri_al
fetial95716193feti_al
feudal1037683fe_udal
fluidal1144653fluidal
fucoidal1443783fucoidal
gavial10310083gavi_al
gelada837623gelada_
geladas936313geladas
gelid74916983gelid__
gelidly1234743gelidly
general81010933general
genipap1243123genipap
genitals937243genitals
geode7412593geo_d_e
geodes8412153geo_des
geodic1048003geo_dic
georgical1344023georgical
germinal1147253germinal
gestical1138983gestical
glial66715433g_li_al
global937663glo_bal
glossal8447053glossal
glottal835103glottal
gnomical1346683gnomical
goal55829303g_o__al
goddam1145163g_oddam
gonadal956523gonadal
gonidial1065943gonidial
gooral7310463g_ooral
goral65125753g_o_ral
gremial1039153gremi_al
helical12311153helical
heroical13410023heroical
jemidar1744163jemidar
lexical1637363lexical
lipoidal1144473lipoidal
medal86221333me__dal
medial93819863medi_al
medical12312513medical
menial84223033meni_al
mesial84818083mesi_al
metical11315363metical
modal85919243_mo_dal
mucoidal1344793mucoidal
nidal65217103__nidal
nodal64717793_no_dal
oedipal1045173oedipal
ovoidals1242493ovoidals
pedal86022503pe__dal
penial84120893peni_al
peridial11411923peridial
recital9412163recital
redial74923113redi_al
reginal84814293reginal
reoil55321183reoi__l
residual9245443residual
retial64724993reti_al
retinal75318353retinal
revisal1038263revisal
revival1337033revival
seidel7311083se_idel
seminal91213403seminal
sendal73314993se_ndal
serial64625863seri_al
sigmoidal1352653sigmoidal
steroidal1045473steroidal
stoical9310283stoical
telial65815363teli_al
tidal64516443__tidal
toroidal966393toroidal
veinal93812963ve_inal
venial94218283veni_al
vesical12159813vesical
xenial133414903xeni_al

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.1431249587.4
2DLD Change Limit1340271127.11018850.5
3Display Results1121120.0303733.3
 (SQL Overall)1786911127.28324535.4
 
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.