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

152 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
ordinal83863(None) 
ordinals946751ordinals
cardinal1139562cardinal
cordial10312942cordi_al
morainal1047202morainal
oedipal1045172oedipal
orbital936922orbital
orcinol944702orcinol
ordeal779252ord_eal
ordinally1346282ordinally
ordinand1044102ordinand
ordinary1244912ordinary
ordinate9310252ordinate
ordines83014902ordines
original956792original
rhinal9510192_rhinal
trinal6516962tr_inal
urinal6614122ur_inal
actinal9312293actinal
adrenal838263adrenal
affinal1336443affinal
albinal937813albinal
anginal8310163anginal
arrival1037563arrival
arsenal739383arsenal
audial7312993audi_al
basinal9310033basinal
binal75323823__binal
bridal9511453br_idal
cardinals1247993cardinals
carinal94318233carinal
clinal8311553_clinal
corbina111911453corbina_
corbinas12229393corbinas
cordials1139623cordi_als
cording113620823cordin_g
cordings123011353cordings
coronal94115763cor_onal
corrival1346153corrival
cortical12412213cortical
cortina91915973cortina_
cortinas102212443cortinas
corvina12229503corvina_
corvinas13238013corvinas
cranial92114683cranial
criminal1248303criminal
dial55935063__di_al
dinar66319893__dinar
encinal949243encinal
exordial1645313exordi_al
final83922033__final
foraminal1444263foraminal
forbidal1444833forbidal
fording123717043fordin_g
fornical1347793fornical
geminal10109913geminal
germinal1147263germinal
gordita945093gordita_
gorditas1043923gorditas
hording123517053hordin_g
hormonal1346633hormonal
laminal94113633laminal
liminal93810673liminal
lording93115233lordin_g
lordings10368503lordings
luminal93711003luminal
marginal1137603marginal
matinal9312603matinal
medial93819863medi_al
medical12312513medical
medina94114093medina_
medinas103411463medinas
nadiral836343nadiral
nodical1049863nodical
nominal92712373nominal
nonfinal1147703nonfinal
ogival1035873o_gival
oidia6314953oidi_a_
optical1149863optical
optimal1145783optimal
optional1047643optional
oral47638123or___al
orbing93312363orbin_g
orbitals1045713orbitals
orcin72716573orcin__
orcinols1044413orcinols
orcins83313433orcin_s
ordain7810403ordain__
ordained1035183ordained
ordainer945223ordainer
ordains879653ordain_s
ordeals877993ord_eals
ordinance1245053ordinance
ordinands1143033ordinands
ordinarily1453113ordinarily
ordinates1049003ordinates
organa789213organa_
orgiac934993orgi_ac
oriel54920423or_i_el
oriental848483oriental
origan7310693or_igan
originals1044843originals
orinasal843563or_inasal
orphical1546733orphical
orpin73415533orpin__
orpine83914483orpin_e
orpines94414793orpines
orpins83614163orpin_s
ovoidal1144023ovoidal
paginal10269493paginal
preanal9310713preanal
predial103815413predi_al
primal104014623pr_imal
prodigal1246003prodigal
radial74020393radi_al
radical103312793radical
redial74923113redi_al
reginal84814293reginal
regnal74812933_regnal
renal55929503_r_enal
retinal75318353retinal
rial45938093_r_i_al
rival85216503_r_ival
riyal84413433_r_iyal
rosinol756323rosinol
ruminal9289993ruminal
seminal91213413seminal
sordine82515233sordin_e
sordines92414073sordines
sordini8228963sordin_i
sordino8219443sordin_o
spinal84915313_spinal
terminal1039733terminal
toroidal966393toroidal
torsional945033torsional
trial54926353tr_i_al
tribal8611133tr_ibal
turbinal1045623turbinal
uncinal959963uncinal
uredial82910483uredi_al
uredinial1043913uredinial
urial54823023ur_i_al
urinals7610253ur_inals
vaginal11288403vaginal
veinal93812963_veinal
vicinal12268543vicinal
viminal12288823viminal
vinal85725813__vinal
virginal1244573virginal
vortical1348863vortical
wording123014563wordin_g
wordings13328563wordings

Search took 7 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.390458182.1
2DLD Change Limit1340271526.03022226.7
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.48327563.0
 
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.