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

289 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
opalines1031142(None) 
opaline9412481opaline_
alines65735222__alines
dopamines1446042dopamines
hyalines14169332hyalines
malines93625602_malines
opines84820702op__ines
outlines82418092outlines
oxalises1538502oxalises
oxazines2434072oxazines
palings103915822_palings
patines95225762_patines
potlines10714212potlines
pralines102217722pralines
salines74029412_salines
splines94718892sp_lines
toplines102412562top_lines
valines104520212_valines
abalones1038753abalones
acarines10314343acarines
airlines8312793airlines
alanines8314803alanines
aliens65619213__aliens
aline57243153__aline_
alined75221403__alined
aliner65621983__aliner
aliners74717723__aliners
alkines114415733__alkines
alpines94016193__alpines
amines84727983__amines
anilines8415143anilines
apatites10311293apatites
aplites9314933ap_lites
apolunes1045293apolunes
applies11311213appli_es
azines155517073__azines
beelines103312803beelines
berlines102315453berlines
bialies93618413biali_es
bowlines133211623bowlines
bylines1239243_bylines
calcines12314753_calcines
calices114321693_calices
canines93724033_canines
caplins113515993caplin_s
carlines103521643carlines
chaines124518733cha_ines
chalices15310813chalices
chalones13312173chalones
cholines132214493cholines
clines84926043__clines
cobaltines14114473cobaltines
cocaines121314443coca_ines
complines15312833complines
corallines1246553corallines
cutlines102413273cutlines
cyanines132710543cyanines
deadlines11138503deadlines
dealings103510703dealings
declines113315803declines
delaines9312963delaines
dialings10329823dialings
diamines11311643diamines
diazines1838713diazines
domaines11611063doma_ines
dopamine1346173dopamine_
draglines1145993draglines
dualizes1838823dualizes
egalites9310503egalites
enamines101112133enamines
etamines101611813etamines
examines17128793examines
famines123216263_famines
felines104718073_felines
flamines13311643flamines
flatlines12268433flatlines
flavines1437893flavines
focalises14139953focalises
focalizes23159323focalizes
gamines103618463_gamines
goalies8316023goali_es
gradines103615253gradines
graplines1237353graplines
guanines989773guanines
gumlines11238573gumlines
guylines12236943guylines
halides113416663_halides
halites103221193_halites
haplites1339993haplites
headlines13119013headlines
hemlines13310623hemlines
hiplines13310593hiplines
hoplites13310543hop_lites
hotlines11811643hotlines
hyaline132310723hyaline_
hyalins13229273hyalin_s
hyalites14208833hyalites
imagines1137463imagines
inclines10313143inclines
isatines8310663isatines
isolines8312303isolines
jawlines18126363jawlines
kaolines1239293kaolines
lawines103313563_lawines
lines57054573___lines
lobelines1138563lobelines
localises111411463localises
localites111210433localites
localizes201510543localizes
longlines1047983longlines
malices114316623_malices
maline84529083_maline_
marines93928013_marines
marlines103818713marlines
mealies92821933meali_es
mealiness11310063mealiness
midlines112613333midlines
millines102718063millines
moraines10314363mora_ines
moralises11314003moralises
moralizes20312863moralizes
myelines1337123myelines
nopales93812523nopal__es
nopalitos1143663nopalitos
obelises1039103obelises
obelizes1937513obelizes
obliges1037143o_bliges
ocarinas1036723ocarinas
odalisks1363503odalisks
offline1345783offline_
oiliness8311563o_iliness
olefines1137323olefines
oleines7313393o_leines
olives94313953o__lives
olivines1137473olivines
online6315843o_nline_
oodlins83210513oodlin_s
oolites72817843o_olites
opacifies1645463opacifies
opacities1347943opacities
opalesces1343993opalesces
opals75718353opal___s
opaques1833643opa_ques
openings1134803openings
ophites12310103op_hites
opine77422463op__ine_
opined95113853op__ined
opsins8411713op_sin_s
optatives1445203optatives
optimes1148473op_times
opulences1345093opulences
oralisms10610973oralisms
oralists8611803oralists
oralities91214123oralities
ordines83014903o_rdines
orpines94414793o_rpines
oscines9310363o_scines
otalgies936393otalgies
outlies72421993outli_es
outline72321333outline_
outlined92512953outlined
outliner82412113outliner
outliners9228363outliners
outlives112511763outlives
ovalities12119803ovalities
ovalness1134673oval_ness
ovaries10312653ovari_es
ovines94614343o__vines
oxalates1557063oxalates
oxalis1339223oxali__s
oxazine2354773oxazine_
ozalids1794063ozali_ds
pagings114411063_pagings
pained95622853_pa_ined
pains75138283_pa_in_s
paints85921833_pa_ints
palaces114216453_palaces
palates93624933_palates
palatines11313033_palatines
paleness10312983_paleness
pales75753803_pal__es
palier85023563_pali_er
paliest93021603_pali_est
paling93530133_palin_g
palinodes1245883_palinodes
palsies94420273_palsies
panes76148693_pa__nes
pannes85522853_pa_nnes
paries84742513_pari_es
parings104219213_parings
parises94827183_parises
patinas96318523_patinas
patine85328123_patine_
patined105114783_patined
patins87528783_patin_s
paulins9312613_paulin_s
pavanes123612653_pavanes
pavings134011633_pavings
pavins114919663_pavin_s
pavises125315493_pavises
pelites93821993_pelites
pilings103313613_pilings
pines76048863_p__ines
pipelines13178353pipelines
plaices11411143_plaices
plained103812233_plained
plainer93811983_plainer
plainest10313613_plainest
plains85019593_plain_s
plaints94012053_plaints
planes85028083_p_lanes
plies74526513_p_li_es
plinks124913263_p_links
polices113118053_polices
polies84034583_poli_es
pollices12410753pollices
poplins11313153poplin_s
potline91015233potline_
poutines102415103poutines
praline93019743praline_
prolines102619693prolines
pulings103511323_pulings
purines94420763_purines
purlines103514053purlines
rapines95120863_rapines
ratines75328583_ratines
ratlines83815293ratlines
ravines104220233_ravines
realises82420183realises
realizes173116843realizes
reclines103718543reclines
redlines93916083redlines
relines75331323_relines
romaines10512523roma_ines
rooflines1245373rooflines
sabines94318483_sabines
salinas73116093_salinas
saline65132703_saline_
saltines82917793_saltines
saplings11269803saplings
savines104417633_savines
scaliness1149303scaliness
sepaline10311343sepaline_
setlines8312743setlines
skylines1535703skylines
smaltines1136993smaltines
sodalites10128693sodalites
solanines9310083solanines
spaciness1337083spaciness
spacings13287043spacings
spadices1336093spadices
spadixes1834113spadixes
spadones1137253spadones
spaeings11276253spaeings
spales84728103spal__es
sparlings12257153sparlings
spavies123012943spavi_es
spavined1434333spavined
spavins12419323spavin_s
spilings11308813spilings
spines85132033sp__ines
splices113914383sp_lices
spline86020533sp_line_
splined105013113sp_lined
splints94511743sp_lints
stanines85115673stanines
sublines10315783sublines
taglines92210833taglines
talipes9611603_talipes
tapelines1138463tapelines
topazine1944983topazine_
topline92313183top_line_
totalises9311783totalises
totalizes18311053totalizes
towlines112610343towlines
tramlines1139843tramlines
traplines11310373traplines
upflings1433733upflings
uplinks13345613up_links
uralites82112723uralites
vahines133410523_vahines
valine94623093_valine_
valises103516263_valises
vocalises141710333vocalises
vocalizes231610103vocalizes
wahines133111173_wahines
walies95324523_wali_es
whalings15256763whalings
yealings12257703yealings

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622896.86021306.4
3Display Results2892890.1102627.3
 (SQL Overall)1786912897.39024180.1
 
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.